If then formulas


I am trying to create my own easy work around to capture the date when something is completed.

IF the Completed Box is checked AND I have a last modified date column

Can I create a date completed box and say

IF the Completed Box is checked, then copy last date modified?

=IF(Completed1,1, [Last Modified Date]1, "")

Does not work... LOL

I am new to smartsheet and need an easy work around to lock this date completed, if possible.

Sorry, I have asked this question before but the answers were too elaborate for me to understand how to do it. Preferably without having to create a new second sheet.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!