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.

Thank you!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!