-
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…
-
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…
-
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…
-
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…
-
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…
-
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…
-
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.…
-
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…
-
Add Delete Rows that Don't Match Filter Criteria Option for DataTable
Because there is no way to delete DataTable entries from a Data Shuttle workflow, I have to abandon the use of DataTable. Because I am unable to delete entries via Data Shuttle, DataTable connections have been pushing out of date and incorrect information to my sheets. I am hoping the DataTable and Data Shuttle product…
-
Assign holidays or non-working days per user/group
As a member of an international organization, staff working on a project will not all have the same non-working days. It would be helpful if people could enter their non-working days into their personal profile (which could then include vacation days in addition to holidays)! Ideally, we could enter groups of non-working…