Date and Conditional Symbol - IF Then Statements
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.
Help Article Resources
Check out the Formula Handbook template!