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.

Rookie Help with Due Date and Overdue

Schultis
Schultis โœญโœญ
edited 12/09/19 in Archived 2017 Posts

I have a start date column, due date column, completed date and would like to have overdue flag column.

How to set formula that if due date passes, no completed date and have flag come up in overdue column?

ย 

ย 

Comments

  • Hugh McKinney
    Hugh McKinney โœญโœญ

    This can be done in conditional formatting Schultis.

    Select conditional formatting in the format area of the tool bar.

    Click "Add New Rule"

    Click on the link <set condition> and select your column name "Due Date"

    In define custom criteria select "is in the past" then click OK

    On the left of the rule you are creating there is a down arrow in a greyed out box, click this and select Add Condition (AND) - a new condition will be added.

    Select the new condition and select the column name "Completed Date"ย 

    From the criteria drop menu select "is Blank" the click OK

    Click on the "this format" link

    You can create an action here that will add an alert in the overdue cells of each row

    I use the paint icon to change a cell red, copy white and text bold

    Finally select the "entire row" link and select the column name "Overdue"

    and your done.

    ย 

    Now if you have a start date that is in the past with a blank completed date the overdue cell in that row will show as red and any copy with be bold white-out

    ย 

    Hope this helps

    ย 

  • Schultis
    Schultis โœญโœญ

    OMG I feel like I tackled the world with just that one thing.ย  I may ask you a few more questions, if that is ok with you.

  • Hugh McKinney
    Hugh McKinney โœญโœญ
  • Schultis
    Schultis โœญโœญ

    In order to use the cardview I need a column that has drop down list.

    Now I have 2 columns basically doing the same thing.

    1 Columnย ย  Status using RGYB balls for Red Not Startedย  Green In Progressย  Yellow for Waitingย  Blue for Complete

    2 Columnย  Stage drop down listย  Not Startedย  In Progressย  Waitingย  Complete

    ย 

    Seems rather redundant to select Red Ball in one column and Not Started in the Other

    ย 

    Does it have to be that way for card view?

    ย 

  • Schultis
    Schultis โœญโœญ

    I would like to have completed date fill in automatically with today's date when I select

    Stage Column Blue Ball (complete).ย  Is that possible?ย  Thanks.

    ย 

    ย 

This discussion has been closed.