Formula Help: Auto updating the stars
Hi,
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
-
So when you say "Start date to current" you are meaning that the Start Date is in the past # days?
If that is the case, then you should be able to use your existing formula and only have to make a few tweaks.
You are going to want to change all of your "less than" arguments to "greater than" and change all of your positive numbers to negative numbers.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Answers
-
Are you able to spell out how you want the formula to work?
For example, your current formula starts off as
If [Start Date] is in the past, "Empty.
If [Start Date] is in the next 90 days, "One".
If [Start Date] is more than 90 but less than 180 days in the future, "Two".
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Hi Paul,
Thanks. Not quite. And now that you have it like that, I can see I'm way off.
Start date in the future = empty
Start date to current is between 0 and 90 = one
Start date to current is between 91-180 = two
ect....
I'm trying to use the start date and the "current date". I hope this makes sense.
Thanks again,
Tony
-
So when you say "Start date to current" you are meaning that the Start Date is in the past # days?
If that is the case, then you should be able to use your existing formula and only have to make a few tweaks.
You are going to want to change all of your "less than" arguments to "greater than" and change all of your positive numbers to negative numbers.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Awesome, that seems to be it. Thank you so much Paul!
-
Happy to help. ποΈ
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.7K Get Help
- 371 Global Discussions
- 205 Industry Talk
- 436 Announcements
- 4.5K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 129 Community Job Board
- 448 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 282 Events
- 32 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!