formula for status column

System

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

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

@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")))