I would like Smartsheet to automatically assign a project status based on duration and number of days behind project. I have specifically been asked to assign a project status of red if the task is 20% behind schedule.
Please let me know if you are aware of how to automate this in SS.
I am trying to work out the best way to do this. I have an evolving list of products (hundreds and hundreds) that can be ordered, and 29 people (only - this is set) who can order them for a Bulk Buy once a year.
My current plan, was to create a Template, then have a sheet for each person. This way
This is a test sheet (screenshot attached). I am trying to set up a method to where an Update Request is automatically emailed to the sales rep 3 days after the trigger date (Bid Date). This functionality is in the Alert Module, but in the Update Request you have to manually set a date each and