Formula Help: Auto updating the stars



I'm working with a semester type project and would like to have the Star symbol used to represent the semester they are in based on a start date. I tried following the example.. .. but I think I'm missing something. Here is the Formula I'm trying to use, based on another example I found.

=IF([Start Date]@row < TODAY(), "Empty", IF([Start Date]@row < TODAY(+90), "One", IF([Start Date]@row < TODAY(+180), "Two", IF([Start Date]@row < TODAY(+206), "Three", IF([Start Date]@row < TODAY(+365), "Four", "Five")))))

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!