-
Dropdown values aren't showing in form using the new dropdown link to sheet
I used the new feature with the dropdown column type where you can reference a single source sheet for dropdown values (thank you, Smartsheet!), but when I am creating my form, it doesn't show that field in the form —- see error message below. Has anybody experienced this and if so, what did you do?
-
Form automation - API
I'm looking to develop a solution for copying forms from one sheet to another, based on matching fields in the forms. I am having difficulty, however in getting forms to appear as an attribute or an associated object to a sheet. What is the correct way to use the API for listing/discovering the forms associated with a…
-
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…
-
elapsed days as a predecessor lag
Please add feature to be able to use elapsed days as a predecessor lag, as can be done with Microsoft Project for when I have tasks that reflect calendar days (i.e., regulatory timelines).
-
Linked Dropdown Columns
Good afternoon, I am trying to utilize Linked Dropdown Columns for a manual process we have. We have many sheets that use a "Client Name" column with a dropdown list. Whenever a new client comes on or exits, we have to manually update every sheet that has a Client Name column and update the dropdown list. We do not have…
-
Smartsheet Filters
I’m hoping you can help me out with a question regarding Smartsheet. We have created a exception report within Smartsheet and I am having an issue with a client row being recognized when a filter is placed on the particular smartsheet. For Example: on the Exception main page you have 50+ clients listed with all exceptions…
-
Date and Time Separator Formula
Hi Community, I'm looking for assistance with creating formulas in Smartsheet to separate a combined DateTime value into two distinct columns: one for the date and one for the time. "Date" Column: Contains both date and time values "Date Only" Column: Should display only the date "Time Only" Column: Should display only the…
-
Creating a report frm several sheets to assign tasks without adding an assigned column to each sheet
I have a collection of sheets (10-12) that all have projects in various stages that need a status review/update. This is a temporary process and I need to be able to assign each project to an employee, but these sheets don’t have an assignment column already built in them. Is there a way to set up an assignment system…
-
making options in dropdown unavailable if selected already
How to make dropdown options become unavailable (in both forms and sheets) once they’ve already been selected. Example: If a patient books an appointment, that time slot is automatically removed or disabled so it can’t be chosen again.