-
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…
-
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…
-
Allowing the Lag days in the predecessor field to be elapsed days
I've run into this issue where by the days I want a task to lag by is an elapsed number. E.g. Predecessor 380FS + e90d. The elapsed day function works well in the duration field.
-
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…
-
Basic Logic for Data Updates
System logic used to 'prompt' users upon data entry to validate that the user is doing something on purpose despite it being illogical. An example would be - entering a date within a date column that is in the past (or future; depending on the actual column).
-
Mandatory Columns in Table / Grid View
Extension of the functionality within the forms, ability to toggle a column to be mandatory for data capture purposes. The benefit of this would be to increase data quality by ensuring that people not using the Forms or updating items are required to populate / update fields to maintain good quality data.