-
LEN() command in an Intake Form
Am I able to show a field on my Intake Form based on a column length. I have the following working on the sheet column =IF(LEN([Short Description]@row) > 15, "Too many characters", "") but I would like another field to show if the Short Description has a length greater than 15. I have a field called Validation Check that I…
-
Automation : Can it leave my manual work current?
I have a Smartsheet that I have been doing a lot of manual "box-checking" for completion. I have a process set up to data shuttle and automate, however, I don't want to lose all the work that I have competed, since I won't be able to shuttle some of the historical data in. Is is possible to have my previous content in…
-
Best Formula to use for Validation between 2 Columns in 2 Sheets
Good Day, Looking for some ideas/suggestions for a formula to use to verify values placed in a column in a sheet. In my scenario, I have Sheet 1 and Sheet 2. Within this 2 sheets are 2 columns that need to match. Sheet 1 - Column: 'Product Category' is a manually entered field. This column/field needs to match or flag when…
-
Compare Pre and Post Survey Results
I have a pre class survey and a post class survey. The surveys include both likert scale and fill in the blank questions. I would like to compare the data from the pre class survey to the post class survey in order to analyze and create metrics on improvement. Any ideas on how to actualize this?
-
How to compare SIMILARITY not exact match in a string of text/description/summary
I am trying to create a formula that compares a New Intake Form's description/summary to completed and Archived Intake Work Form's to see if this is a project similar to what has already been worked on in the last 5 years. I am not looking for an exact match, but something similar enough to pull the Old "Intake Request ID"…
-
(Grid View) Cell and Column Data Validation Rules
What if we could add required value and data validation rules to any text/number columns. This could be to enforce either blank or a value matching the formatting, but would help with data validation across the board. My use case, in particular, is that I pull in data from Smartsheet to a data model and data visualization…