Formula to add today's date when ALL checkboxes are done.


I have a list of tasks and each task has 5 child tasks. All have separate due dates, they have a completion check box and a completed date. I have an easy formula in the completed cell to auto-populate the date when the completed box is checked and it works great! =IF(Complete@row = 1, TODAY())

What I'm trying to do is put a formula in each Parent row, in the completed date cell that will auto-populate the date when all of the children boxes are checked. Is that possible? Column names are simple, the check box is "Complete" and the date column is "Completed Date".

Thanks so much!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!