Change just once a formula used several times


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

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!