Unticked boxes to trigger reminder dates

pea.ccu49236

pea.ccu49236 ✭

05/29/18 edited 12/09/19 in Smartsheet Basics

In my project sheet, I have a Task Complete tick box.

I would like a date to be placed in the Reminder Date column if the box is not ticked by the Estimated Delivery Date.

Is this possible?

Tags:

0 ·

Comments

L_123 ✭✭✭✭✭✭

05/29/18

=IF([Task Complete]1 = 0, TODAY(), "")

Will post todays date if the checkbox is empty. Change today() to whatever equation you want in that formula.

0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

Multiple Approvers on one Approval Automation?
My sheet has multiple approvers who vary by the row depending on certain criteria. I want to send them all the row approval request at the same time, then when they all click approve the project can move forward. To count when the responses are all in, I am moving the entry to a new sheet and counting the references that…
Can I use a condition to remove a user from receiving weekly notifications on an automation?
I have a weekly automation set to send to everyone in my 'owner' column. As each owner completes their assignment, they no longer want the weekly reminder to do their work. How can I remove them and keep the rest?
"Record a Date" Automation to a Cell in a Hidden Column
I have lots of sheets for a reviewing process - each item to review has a new sheet from a template. Each sheet has about 30 rows and a summary sheet. I have an automation that does the following: When "status" cell changes, request an approval. (This is calculated in a summary sheet and written to a cell.) Approval comes…

Help shape the future of Smartsheet.
Share your ideas and feature requests.