-
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…
-
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.
-
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.
-
I don't understand my Sheet Summary formula
I've been using sheet summary formulas for a week but have been struggling with something I don't understand all afternoon. I have a summary field called % Planned Complete. For simplification, I'm testing this formula: =INDEX([% Planned Complete]:[% Planned Complete], 21) * 100 But it won't return the value for row 21 in…