Calculate a review date but only if %Complete is 100%



I have an "End" date column and I can calculate out 12 months using:

=[End]@row + 365

However, I would like to have this date populate the cell only if the "%Complete" cell, in the same row, is 100%. In other words, the cell will be blank unless the task is 100% complete.

I tried the following but get the parse error.

=IF([%Complete] 9 = "100%", [End]9+365)

=IF([% Complete]9 = "100%", End9 + 365, "")

I definitely need help!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!