Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Current date v. due date

John Carter

John Carter ✭

03/15/17 edited 12/09/19 in Archived 2017 Posts

Is there a way to keep a today's date column that automatically changes every day so that one may see the due date of a task in relation to current date?

0 ·

Comments

John Carter ✭

03/15/17

Disregard. I found the answer.

0 · Share on Facebook Share on Twitter

This discussion has been closed.

Categories

Trending Posts

Add to INDEX formula to account for blank cells?
I have a mapped column that displays a Contact based on what's inputted in another cell. E.g. Slim J = Slim Julian. Here's the formula: =INDEX({PD - NetSuite Name Mapping USE Range 1}, MATCH([PDS Selected]@row, {Formstack Name}, 0)) However, if the cell is blank, it just assigns the first Contact alphabetically, even…
Record a date when a status changes from closed to open
I have a tracker where I am tracking dates when tasks are closed, but I'm running into an issue where some items are being "reopened" for additional follow-up. What I want to do is know WHEN that happens (so I can track trends or culprits LOL). Is there a way to record a date when this happens? My record a date workflow is…
QR Codes/Bar Codes
Dear Smartsheet Community. Is there a means within Smartsheet to allocate a unique QR/Bar Code to a specific line in a grid, such that if you subsequently scan the code (outside of Smartsheet), the specific line/data record can be accessed? For now, I am thinking of an image of the relevant code added in a cell as an…