Unticked boxes to trigger reminder dates

Options

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
Options
=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

Is there a way to see if my sheet is being referenced?
I have a sheet I would like to delete but I want to make sure it is not being referenced or being pulled into a dashboard. Can I do that?
How to have separate data table for a new version of the form?
Hi All, I created a copy of the form I used so far, to ask a bit different questions and to collect the data in a bit different way. After the pilot stage I want to decide which version 1st or 2nd of the form will be used as the final version. But I see that the data punched into this 2nd version of the form are collected…
Auto populate name
Is there a way to auto populate a name based on what user checked a box? User checks an column, the column next to it auto records that user as the "checker"

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