Workflow/automation based on sheet summary fields.
One scenario - count of all cells, send a warning if the sheet is close to max.
(Do not want helper column as that increases the count.)
I would like to see this. I have a scenario where a user wants to send reminders when a sheet entry (from a Form) has not been made for that day (reminder at noon). Since no row record exists, it's hard to do. But with a Sheet Summary formula for 'entries from today' we'd have either a value of 0 or greater than 0. Then an automation could be run based on noon each day, if the Summary Field is equal to 0, send e-mail.
I've got a plan for a workaround, but that's going to include creating another sheet (summary sheet), which at this time is not really needed for anything else.
Could not agree more. I would upvote a 100+ if I could. In general Sheet Summary fields are a powerful opportunity that is not being utilized. I know this idea is specific to automations, and I strongly upvote that.
But there are so many situations where I only need one data point (today, first/last day of month, most recent row modified date, etc.), but the default work around is a 'helper column'. I have so many helper columns in my template its becoming unwieldy... and I am sure its not helping the speed.
Example helper columns in my sheets where it is storing only ONE PIECE of data for the entire columns: Today helper, Project Director Helper, month 1 start day, month 1 end day (another 10 columns months 2-6 for financial projections), Contract Number Helper, Project Name Helper, Client Helper, Assigned Accounting Helper, Global last modified helper, and I think 5 or 6 more... its like 20+ helper columns, all running redundant formulas for one peice of data... I would gladly move this all to summary data... but its not very helpful there.
Can't do global updates to sheet summaries from control center
Can't run automations from sheet summaries
Can't use workflows from sheet summaries (without more helper columns)
I know its one idea per post... so I'll search the idea posts and see if these other use cases are covered as well.
Hi Community, Welcome to the Product Feedback and Ideas space where you can help shape the future of Smartsheet! We really appreciate your feedback and will take all posts into consideration. Our product team will review top ideas and requests monthly and we'll share updates as soon as we get them. Remember: if you have a…
It would be great to be able to group columns... for various reasons. One major one for me would be for hiding & unhiding info. Similar to the way you can click the filter button once to filter versus unfiltered, it would be nice to be able to "Hide Column Group" or "Unhide Column Group"... this is something that would…
Although it's typical to need to run a few tests for a workflow or automation, it would be great if we had the option of previewing what the automated emails/notifications/alerts would look like for individual users with different types of permissions. A view "View As" type of feature.
When a project and tasks are set up with dependencies and durations, the project manager should be able to drive all task dates based on the project end date, not just the start date. Often mid project the delivery date needs to be changed. With Smartsheet, a project manager needs to adjust the duration of all tasks…
©2023. All Rights Reserved Smartsheet Inc.