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

Hello,

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!

Pam

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!