formula for status column

This discussion was created from comments split from: Status Balls & Date formula.

Answers

  • Abe B.
    Abe B. ✭✭✭

    Hi,

    Thank you guys for this valuable thread. I been trying to set up a formula for the following case, and would appreciate if someone can help me creating it:

    I have 3 Columns:

    a RYG status column. I also have (Due Date) column that is set to be 10 days from (Date of entry) column through a simple formula. and lastly a check box column to manually check whenever a transaction is completed.

    I need a formula for status column to reflect the following:

    • Show Y if (Date of Entry) is today or 9 days in the past, unless the check box column is marked, then show G.
    • Show R if (Date of Entry) is 10 or more days in the past, unless the check box column is marked, then show G.
    • Whenever the check box column is marked, then always show G. "this might be repetitive, that we don't need if included in the previous formula part)
    • Thank you
  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    @Abe Balatya Try something like this...

    =IF([Checkbox Column]@orw = 1, "Green", IF([Date Of Entry]@row < TODAY(-10), "Red", IF([Date of Entry]@row <= TODAY(), "Yellow")))

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!