New to Smartsheet - Setting alerts once status has changed
I hope you are all doing well.
I have tried to incorporate Smartsheet into my daily workings and hope you may be able to help. Seemingly, Excel is far easier when setting rules, but with automation needed I decided to use Smartsheet.
Currently, I have a project on hold sheet which records all projects that are placed on hold. I need to be aware when a project has been on hold for 90 days, so created =[Column6]@row + 90.
Then, I created a status column (Believe this is what I need) and created =IF([Column8]@row < TODAY(+5), 1, 0). This helps me identify when a project is above 5 days or below.
I was going to use this to then create an alert to when the status changes from 0 to 1, an automated reminder is sent.
This is obviously extremely basic, for one, I would rather have 3 choices. Yes with the green tick (Plus 5 days from todays date), Hold with the orange exclamation mark (between 5 and 1 days from todays date) and red with the X mark (Todays date and any date past).
Too, I cannot work out how to get the status column to actually show statuses rather than 1 and 0 in my original IF statement.
All of the above I have picked from various comments on the community, so if there are easier ways please feel free to advise. I'm all ears (Almost literally).
Help Article Resources
Check out the Formula Handbook template!