Date isn't today <> ""
The below formula was suggested by the community experts, but I had a follow-up questions:
=IF([Target Start Date]@row <> "", IF([Target Start Date]@row <= TODAY(365), "Advanced", "Experts Only"))
What is the purpose of the first part of the formula where it says, "IF([Target Start Date]@row <> "". Why do we need to check if theTarget Start Date isn't today?
Help Article Resources
Check out the Formula Handbook template!