-
New column type: Currency-only
I see there’s already an idea requesting a "Number only" column type, and I’d like to suggest adding a "Currency only" column type as well. Currently, I have to create several workarounds to validate certain fields we collect. For example: Ticket number or Purchase Order number fields should only allow numbers and have a…
-
Duplicated data on some columns / rows
Hi We set up a basic sheet at work to collect data from around 400 sources using a form submission. We have used this many times without any issue but this time the first 60+ submissions /rows are fine, the next 19 seem fine other than 6 columns, not together have exactly the same text in (word for word) from unrelated…
-
Copy and Pasting Multiple Rows from Excel into One Multi Dropdown Select Cell in Smartsheet
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 Market as an offer associated with it in column D. So essentially these markets in column c are grouped by the Offers in Column…
-
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…