Can we dynamically pull values from formula row depending on dynamic quarter and year? — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Can we dynamically pull values from formula row depending on dynamic quarter and year?

edited Aug 20, 2025 7:29AM in Narrative Reporting 3 comments

We want to pull values in current quarter and previous quarter dynamically from the formula row. Is there a way to do it using IF formula or any other way? In the below screenshot, need to pull yellow highlighted cell values dynamically from the green cells depending on dynamic Period and Year in the yellow highlighted columns.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!