Good Morning fellow smartsheeters!!! Is it possible to copy and paste multiple rows from excel into one cell in smartsheet when that cell is apart of multi dropdown select? For my use case, Each Marke…
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 lik…
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 c…
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 ne…
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 s…
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 o…
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 …