Smartsheet Support Documentation does not have a way to duplicate, copy, or export a group in admin.smartsheet.com/manage/groups There is, however, a workaround that doesn't appear to be posted anywhere so I'm sharing it here: Open the group in the group list at admin.smartsheet.com/manage/groups Select "View Group" Select…
This is the simplest formula I can find to add Months to Date. This considers sum of months exceeding 12, converting it to January and adding 1 to the year. Where: Term column is the number of months to add, Date is the starting date. =DATE( YEAR([Date]@row) + INT((MONTH([Date]@row) + [Term]@row - 1) / 12),…
Using URL queries to pre—fill forms seems to be catching on a bit more lately. There are a lot of resources out there, but they can be kind of spread out, so I figured I would start a thread that has some of the lessons learned, tips, and tricks that I have discovered along the way. Tip #1 [info callout] The first one that…
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…
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…
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…
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…
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…
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…
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?
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"…
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…
It looks like you're new here. Sign in to post and engage.