Setting up Automation correctly - TODAY()
I am using a To-Do-List in Smartsheet that works well. As new tasks come to hand, I drop them on the list for future action. I have a simple automation that emails me at 8am for any tasks that have a Due date today (and not already completed).
What I would like is for the Automation to email me for all activities that are Due today AND those that were due prior to today but not yet marked complete. That way I get a consolidated list of all outstanding activities.
Two possible solutions:
- Reconfigure Automation, but I can't see how I can do that
- Create a new column with a IF(AND) formula that compares the Complete Column to the Due Date column and applies a <=today() formula.
Any thoughts would be appreciated.
If I can get it to work, I should be getting a list containing only items 2 and 4 above (Item 1 is in the future) at time of writing.