Change just once a formula used several times

Angela Formiga

Hello,

I have a sheet that it is a summary of several sheets and I have a lot of formulas that use date like "<=DATE(2020; 9; 4))" and I want to change that part of the formula to for example "<=DATE(2020; 9; 6))" and just do it once because I have that several several times.

Is there any way to do it?

If I try to search for that part of the formula says that does not find match (image below)

Best Regards,

Angela Formiga

Andrée Starå

Hi @Angela Formiga

Unfortunately, it's not possible at the moment, but it's an excellent idea, and it would be fantastic to be able to search in formulas!

Please submit an Enhancement Request when you have a moment

As a possible workaround, you could add a unique character at the start of the formula that isn't available anywhere else in the sheet. Then you can use the Find/Replace to replace/update the formula, and then you'd do the same with the unique character to activate the formulas again.

Make sense?

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Angela Formiga

Unfortunately, it's not possible at the moment, but it's an excellent idea, and it would be fantastic to be able to search in formulas!

Please submit an Enhancement Request when you have a moment

As a possible workaround, you could add a unique character at the start of the formula that isn't available anywhere else in the sheet. Then you can use the Find/Replace to replace/update the formula, and then you'd do the same with the unique character to activate the formulas again.

Make sense?

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Angela Formiga

Thank you @Andrée Starå

I registered the enhancement.

Andrée Starå

@Angela Formiga

Excellent!

You're more than welcome!