-
Forms and formulas
Hello, I am new to Smartsheets and am creating a form to send out and collect orders from customers. Now the form works but I need it to populate the new rows that get added with pricing from another sheet. Is this possible as I am not finding any info on this but then again I am new to the site. I would also like to know…
-
Forms
Is there a way to make templates for Forms and then add them to each of our projects? I see where you can build forms and then clone them inside of a sheet but we would be looking to copy those forms into other sheets. Is there an easy way of doing that? Thanks!
-
Checkbox checked, cancel RYG
Hello, I have created 3 columns for the RYG, if the project is in the early stages the color green will show, if it is due within 4 days, yellow will show, and when it is due in 2 days red will show. Now I have a checkbox for the employees to click if the work is complete and I want the RYG colors disappear when they click…
-
Form Submission Organization in Sheet
Is there a way to automatically move a new form submission to a nest under a particular row? For instance, I have 4 parent rows that nest several rows underneath and would like any form submissions to automatically be assigned under one of those 4 parent rows based on information that's submitted (if this, then nest under…
-
How to change the sender email address when Sending Link to Form?
We use a web form as client survey but when sending it typically goes to the client's junk/spam folder because it's coming from "John Lee via Smartsheet <user@smartsheet.com>" instead of my email address which they have already interacted. This is negatively impacting our ability to communicate with clients as we have to…
-
You do not have permission to edit forms on this Smartsheet
I am the Owner of a Smartsheet, ID #4329033635784580, and have already created 22 forms for it. I cloned the last one I created and edited it. When I tried to save it, I received the error, "You do not have permission to edit forms on this Smartsheet." Why can't I save this form on the Smartsheet? Is there a limit to the…
-
Trying to have autonumber show in a webform.
Hi all, I am creating a survey in SS, with a form for collecting answers. I'd like to use a auto number column as a way to create a unique ID for each row. However, I'd like that unique autonumber to show up in the form. This is so users when filling out the form, can see the unique ID associated with their submission. Any…
-
Auto populating Formula Issues
I have an existing sheet with formulas to compute "netdays" left for a task, the task and variables live on the same row. That sheet has a form which allows for a user to add to the sheet a new task and assign, within the form, a start and end date. These dates are the variables that contribute to the formula. My issue is…
-
Import Google Forms?
Hello. New user so forgive my ignorance. I'm testing the potential transition of many of my current G Suite functions over to Smart Sheet. Currently, I use a Google form to input daily information which compiles to a Google Sheet. To save time, I would rather import that Google Form rather than creating a new one in…
-
Date and time stamp updated by day light savings
We have a number of Smarttsheets that are populated by web forms. The date and time stamp information that was entered prior to day light savings have now changed to reflect a "fictional time". In other words, an entry that was added at 6:00 am two weeks ago, now show a 5:00 am entry time. We need the historical…