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.
Deadline column from Creating A Master Calendar video...
![davec123](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
In https://learn.smartsheet.com/master-calendar, the presenter uses "Gantt Project With Hard Deadline" template to create projects, then in Report Builder uses the "Deadline" Column for filtering. However, when I use this same template, there is no "Deadline" column, nor is there a "Deadline" column available from the menu. Is this an outdated video begging to be updated? How can I create an equivalent "Deadline" identifier for searching?
Comments
-
Hello,
From watching this video, the instructor changes the name "At Risk" flag column to "Deadline."
The report will bring in any "Deadline" row that is checked (flagged).
You'll want to change the "At Risk" to "Deadline" in one of the sheets, then save a copy of that sheet (right-click the sheet name at the top and select Save as New).
One extra tip (that doesn't appear to be in the video, but I could've missed it) is that you can automate the checking/flagging of your "Deadline" column with a formula. You can put an IF statement like the one below in the column to automatically check the box when the deadline is reached:
=IF([End Date]1 => TODAY(), 1)
Note that you'll need to open each sheet and save them when you need to have the TODAY function update to the current date. More on the IF function and TODAY function can be found in our functions list: https://help.smartsheet.com/functions
-
Hello,
From watching this video, the instructor changes the name "At Risk" flag column to "Deadline."
The report will bring in any "Deadline" row that is checked (flagged).
You'll want to change the "At Risk" to "Deadline" in one of the sheets, then save a copy of that sheet (right-click the sheet name at the top and select Save as New).
One extra tip (that doesn't appear to be in the video, but I could've missed it) is that you can automate the checking/flagging of your "Deadline" column with a formula. You can put an IF statement like the one below in the column to automatically check the box when the deadline is reached:
=IF([End Date]1 => TODAY(), 1)
Note that you'll need to open each sheet and save them when you need to have the TODAY function update to the current date. More on the IF function and TODAY function can be found in our functions list: https://help.smartsheet.com/functions
-
I appear to have missed that half-second of the video ;-)
Thank you...
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives