-
PDF of original form submitted with approvals printed on it
We have a payment request form for staff requesting a reimbursement for expenses that feeds into an approval path for the supervisor and then the director. This works great, but I also need the trail documented to attach to the accounting system when I put in the reimbursement. Is there any way to get a "final" copy of the…
-
default formula in hidden field
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…
-
Data Shuttle - add in rows with out Unique Identifiers
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…
-
Forms in Sheets
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
-
Is there an automation/formula that allows a copied row to be updated?
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…
-
Merged: Enhancement Request: Logic and Helper Texts for Request Update Workflows
This discussion has been merged.
-
Report Help Needed - Mileage recording for multiple people/entries mobile report issue
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…
-
Can you make Form logic more advanced?
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…
-
Logic in Forms - not optimal
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…
-
Create a form from Smartsheet data
Here is an odd idea that we want to determine if it will work with Smartsheet. Our associates should be able to fill out a form and send it back to our offices, where it will immediately update in Smartsheet according to the entered categories. We are hoping we can then pull this information by monthly update to present on…