We use Smartsheet for project management. The stakeholders would like a notification when the timeline for the project increases. The ability to set a workflow to trigger if a date field is greater than a specified date would also be helpful.
Sign in to see the current vote count, add your own vote, or leave a comment.
It would be great in general if they would add comparative triggers that could compare values in two columns. That way you could do something with a helper column like "When End Date changes, If End Date is greater than Previous End Date, then alert contact in Notify column, plus update Previous End Date to End Date - If End Date is less than Previous End Date, then update Previous End Date to End Date".
Improvements to the conditions and triggers in both conditional formatting and workflows would provide a great deal of value for all. This same thing should translate to Update Requests so that you can send update requests for Column headers that equal a certain value. That would allow you do things like request an update for column W2 when week 2 is next week. Currently if you want to do something like this you have to setup individual update requests for every week of the year. Same thing with conditional formatting - you end up having to make 12 copies to highlight the "current month" or 52 copies to highlight the "current week".
I have a workflow with nearly 40 automations, half of which are email-based requests for updates with various sets of triggers. While I know the automations work, due to months of testing, when our system went live to the institution, I became very worried that the automations wouldn't run and I'd have no idea whether or…
Description: When users upload multiple photos in one action via the Smartsheet iOS mobile app, all files are assigned the same generic name and timestamp. This makes it difficult to identify individual photos and creates confusion in workflows that rely on accurate, unique file naming. Why This Matters: Industry Standard:…
I am proposing bringing a bit of pizzazz to Smartsheet by having celebratory animations for certain criteria. Think Joyful Animations in Outlook! My team was hoping to have some sort of confetti pop/gif/image when we close out a project or hit a milestone. Bonus points if it is configurable like the automations are.