Automatically set a date based on a checkbox

steve50951 ✭✭
edited 12/09/19 in Formulas and Functions

I want to be able to automatically set a due date of the next day based on a 2 criteria 1) a check box is checked, and 2) a cell having text in it. 

For example (we do cabinet installations)...A check box for "repair doors needed" is checked, AND "Repair door sizes to order" cell has text in it. When those 2 criteria are checked, I want to automatically fill a "Repair Date" cell with the next day's date. 

Thanks for your help! 




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!