-
TODAY-based formulae updating cell information should not change the "Modified Date"
There are multiple instances where I have tried to implement automations that would perform an action (clear cells, update information, etc) based on when a given row was most recently updated (e.g. a daily automation whereby any rows that have not been updated that day would have their "Daily Totals" columns erased so…
-
Resource Management: Email Notification for Project Budget Thresholds
Notify project stakeholders when project budget is 50%, 80%, 100% consumed. This would be a proactive notification for a Sales Account Manager or Project Manager working across many accounts/projects. The project stakeholders could be identified/specified in the project settings, or if it is a Smartsheet linked project…
-
Resource Management: Clear Suggestions - Ability to turn this feature off.
In resource management, It would be great to have the ability to turn the suggested hrs off. Ideally at a project level. For some teams it may be useful, however for others its a burden as the allocations are mostly incorrect. If someone is across more than one project, e.g. working on "client A" Mon + Tue (40%) and…
-
Limiting attachment access by license
I have run into a situation where I have confidential documents attached to a worksheet row that need to be available to certain personnel. These same worksheet rows are also accessed by personnel that should NOT have access to these documents. I already have hidden the attachment column, and several other columns that…
-
Allowing Multiple Smartsheets to be published to One Google Calendar
I would love to be able to publish several of my smartsheets to one google calendar so everything is in one place. Please let me know when this feature maybe added! Thanks
-
Leads and Lags / Fast-Tracking Project
Smartsheet could consider creating a formula to lock a specific cell since it is sometimes necessary to block a successor date; it is difficult to add leads and lags and not move other dates, for example, when used in projects with fast-tracking compression.
-
Owner access to 'Sheet Access Report' for their shared items
We have owners with many Smartsheet items, who would like a way to be able to see their own shared user list across all their items via a version of the 'Sheet Access Report' that is only available to System administrators. Is this possible with a type of owner report, or will sheet access only be available system…
-
Automations: Sending Attachments individually, selectably
Currently, automations containing attachments can be sent listing multiple attachments to a given row. It would be very useful to filter or select individual attachments (based on a conditional factor such as if the title of the attachment contained a certain string of text, numbering convention, or even file type) to…
-
Automation Workflows - Alert Someone - Ability to see full distribution list
The Automation Workflow to alert someone when certain actions occur is a wonderful feature. It would be a great enhancement to have the email show everyone who receives the notification. A lot of times, the workflows are setup to alert multiple people, but the email comes through as showing only the recipient. Sometimes…
-
Expand time-based automation conditions to include "hours or time"
Per my previous idea, TODAY-based formulae updating cells affects the "Modified Date" column which then prevents automations whose conditions is based on whether something has been updated "today" from functioning. On alternative idea to address this deficiency is to include "hours" of "time" as a automation condition…
