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...

Options
davec123
davec123
edited 12/09/19 in Archived 2017 Posts

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

  • Shaine Greenwood
    Options

    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
    Options

    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
    Options

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

    Thank you...

This discussion has been closed.