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.
Could somebody please help with formulas and reports
I have created an action date column on all my spreadsheets, I would like this populated by default with today's date.
I would then like a report running in the background letting me know if any lines become overdue i.e. in the past - I plan to display this on a large computer screen visible by all users
If anyone can point me in the right direction with this, I would be very grateful.
Thanks in advance
Roly
Comments
-
Roland,
There are a lot of questions here that are unanswered, so difficult to give you the 'right' answer.
It is difficult in Smartsheet to have a default and then override it later with a manual entry. Dates in WebForm are even trickier.
If the default is based on when the row is created, take a look at System columns
https://help.smartsheet.com/articles/1964567-system-columns
You can add a column to capture when a date is in the past
In a checkbox type column, this will be checked when overdue:
=IF(TODAY() > [Due Date]23, 1, 0)
for the [Due Date] column, row 23.
You can find info on formulas here:
https://help.smartsheet.com/articles/775363-using-formulas
Hope that helps.
Craig
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives