I have been waiting for find/replace within formulas, but wondering if there is a different way to solve my problem. I have raw data in quarterly sheets that feed an annual sheet where the data is broken out monthly for the whole year. Every year I create a new annual sheet and have to update the formulas with the references for the new quarterly sheets.
An example of the most basic formula I have on the sheet is below. I am using sheet reference names and a helper column for the dates. The overall process works great, it's just a huge pain to manually update hundreds of "FY25" with "FY26".
=COUNTIFS({FY25 Q3 Facility}, $[Full name]@row , {FY25 Q3 Date}, >=($Dates$6), {FY25 Q3 Date}, <($Dates$7)
Note that I'm limited to Pro so can't achieve the end result with sheet summaries. Thanks for any other ideas!
Erin
PS. If find/replace within formulas is the answer, can someone post the link to the idea for upvoting? I found too many threads on that subject and not sure which one to ping to get Smartsheet's attention.
