Date and Conditional Symbol - IF Then Statements

Amy Evans

Target Start Date.png

Project Timing.png

Hello,

I have two columns:

1) Project Timing - A column with symbols. I only want to use the single and double diamond (ignoring the other symbols).

2) Target Start Date - A date when the project will start (can be in the future or the date may have passed already).

How do I create a conditional statement that shows a symbol under Project Timing Column that says:

If the Target Start Date is in the past or within the next 365 days, show a single diamond.

If the Target Start Date is past the next 365 days, show a double diamond.

If neither condition is met, for example a missing Target Start Date, then show a blank value.

Thank you!

Amy

Paul Newcome

Try something like this...

=IF([Target Start Date]@row <> "", IF([Target Start Date]@row <= TODAY(365), "Advanced", "Experts Only"))

Paul Newcome

Try something like this...

=IF([Target Start Date]@row <> "", IF([Target Start Date]@row <= TODAY(365), "Advanced", "Experts Only"))

Amy Evans

Paul,

Wow, this is really well written. I attempted, but my statement was much clunkier.

Thank you!

Amy

Paul Newcome

Happy to help! 👍️

Sometimes it just takes a fresh set of eyes. Haha

hcosta52671

I'm having trouble following that. Where is the "THEN" in the If-Then statement?

Paul Newcome

@hcosta52671 Exactly what are you trying to accomplish? The basics of an IF statement are...

=IF(this is true, then output this, otherwise output this)