-
The "Master Program View" (Dynamic Sheet Aggregation)
Problem: Current Limitations Reports are "Flat" Lists: Current Reports can aggregate rows from multiple sheets, but they function as static lists. They cannot perform project logic (dependencies, duration calculations) across those sheets. No Cross-Sheet Critical Path: There is no native way to identify a "Critical Path"…
-
Form Receipt option to send to others as well.
In the form settings option, as it currently stands, there is only an option to check a box to send a "receipt" of completion to yourself. I need the option for my buyers and assistants to send the "entry receipt" to not just themselves but also to an email address that they designate. Can you please add an option to "also…
-
Prevent row change automations triggering when new rows are added
Currently any form with column formulas will trigger row change automations every time a new row is added. This results in both the new row automation AND row change automation sending every time a new row is added. Both the column formulas and different messages for new vs changed rows are necessary so just using row…
-
Restricting a column to a number value
I know that I can restrict a column value to a number through the form, but if there is a direct entry into a column, our current option is Text/Number. It would be nice if they would separate that into a choice of Text or a choice of a Number. I constantly have an issue with people putting in N/A which causes issues with…
-
Column definitions report
we have to Validate any of the items we build that interact with FDA processes in some way (GxP, if you will). Something that would really simplify this process would be if it was possible to download a configuration file for a given sheet. Ideally, it would contain definition of all the properties for each column, and any…
-
Date/Time field should be Date&Time field
Timestamps are only included on Created Date and Modified Date but it is useful to have a specific timestamp that will not update every time the row/sheet is modified. This would be a huge help especially when using the Duration field or other formulas. Either update the Date/Time field to include the time like Created…
-
Enable Dynamic Variables in Email Subject Lines for ‘Send as Attachment’ Feature
Many users need to automate report deliveries with contextual information (e.g., month and year) in the subject line, similar to how Automations allow cell value references. I propose adding support for dynamic variables (e.g., {{ColumnName}} or date placeholders) in the email subject and file name when using the “Send as…
-
Updated User Role/Permissions to allow Template Sheet Creation by ALL EDITORS/Admins/Owners
Allow Templated New Sheet Creation by ALL EDITORS/Admins/Owners. I understand restricting new grid/report/etc. creation WITHOUT A TEMPLATE to all Editors/Below. However, restricting Templated new sheet creation for Editors/Above defeats the point of creating a template to allow team based scalable project workflows. The…
-
AUTOMATION SEND FROM: FULLY CUSTOMIZABLE MAIL DOMAIN
I've made an automated mail that is informing our clients about their project. But, the main issue is that the @smartsheet.com @app.smartsheet.com is often ending up in their junk or spam folder. So, my wish is that the Send from function could either be the mail adress of a contact in a certain cell or just a fixed value.…
-
Column Formula & Automation Gaps in Global Updates under Control Center
I am loving the capabilities in Global Updates under Control Center.However, there are some gaps I would really like addressed.Can we please create a Global Update option to do the following: Update a column formula not just a cell formula Update an automation Note: I know that I could create a new column and delete the…