Using formula output in another formula- problems?


Hi All-

I have an IF formula that I am using to compare before/after a date. All columns are dates (column type), but 2 of the columns are calculated dates- meaning, the dates are calculated from other sources (i.e. Date1+ 30)

When I try to use that output in my formula, it will not correctly calculate the True/False values if the criteria changes. However, if I write the IF formula against a date column that is not a formula result, it works perfectly.

Is there a limitation for using formula outputs in another formula?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!