Can you write an IF/THEN statement to return a date when the checkbox is clicked.


I have a column which assigns a specific department a task when the button is checked. I would like to populate the assigned date based on this check. So when I assign to purchasing by hitting the check mark, the assigned date column is automatically filled with todays date.

I'm not the greatest at if/then so any help would be great.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!