Deadline column from Creating A Master Calendar video...

davec123

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?

Shaine Greenwood

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

Shaine Greenwood

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

davec123

I appear to have missed that half-second of the video ;-)

Thank you...