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
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives