I need to reference the content from one field in another field on the same row. I want the formula as the Default Value of a hidden field on a form. The formula I'm using is =[Team Member]@row. When a new form is submitted, the field with the formula shows a single quote mark at the beginning, and therefore it's not…
The concept of this idea for the "Data Shuttle" aims to overcome the current limitations in data integration, specifically focusing on accommodating users who wish to incorporate rows without the requirement of unique identifiers. The Challenge with Unique Identifiers: At present, Smartsheet mandates the presence of unique…
I have FORM(s) that I use in several Trackers (columns are common across the Trackers); now I need to make a major overhaul on the FORM(s); they are exactly the same in all Trackers. Please tell me I can modify 1 of the FORM(s) and copy across to the other Tracker(s)? Susan
I think it would be beneficial to have a side bar shortcut to forms, since forms sit in the sheet it would be super to have a quick way to access. Thank you in advance for your consideration.
I have created a master sheet for grant invoicing. We have 14 different institutions who received the grant and who will be submitting invoices to the master sheet. I have created a workflow for each institution so that when they submit to the master sheet, that row will be copied to a separate Smartsheet with just the…
This discussion has been merged.
Greetings- The park district where I work has a healthy adventures program where people can enter mileage earned in different categories and groups (via SS form). So the same person (and I don't know who they are in advance bc it can be anyone) can enter multiple entries throughout the year. John Doe entered 15 miles of…
I really love the logic in the form but IMHO is not optimal & describe with screenshots my problem also here. I created a form with 7 question and based on the answer either another question gets visible or there is a message a message in RED. If someone manages to get to the 7th question depending on the answer he can get…
Dear Community, I have a problem with the Form we used a lot of logic so if the person choses proper answer another question is shown. If the question is not optimal there is message in red shown (using header). So if someone clicks all proper answers he is shown with the last question and based on it there are 3 messages…
Hi Community, We just enabled a forms enhancement that many of you have requested: field validation. You can now add real-time validation to Text/Number fields to help collect error-free numbers, percentages, email addresses, and phone numbers. Email validation is also available for Contact fields. We think this will be a…