I have a check box for completed, I would like my Date Completed box to AUTO populate todays date wh

I have a completed column with a check box. When that box is checked, I would like the Date Completed box to auto populate with Todays date. Is that possible?

I tried =IF(Complete1 = 1,TODAY(),"")) but that does not work... ugh

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!