-
Sum column from form submissions
I have users inputting data using a form. The data comes into my sheet at the top. At the bottom of my sheet I have a cell that is summing the numbers in a column called "Sales Amount". Each time a new record is added at the top however the formula summing the "Sales Amount" is not being included. My formula is…
-
Using Forms as a Checklist
Hi I have a list of 96 items which need to be checked off as a QA task. I have the 96 items in the Primary Column and I have 8 further columns, four checkboxes for "Compliant", "Non-compliant", "Unable to Check" and "Not Required", one plain text column for "Comments", one contact list for "Next Action For" a text column…
-
Schedule Form Deactivation?
I'm doing trivia through SmartSheet forms. Everyone who is participating has until Friday at 11am to submit their answer. I know I can physically go into the form and deactivate it. Is there a way to schedule the form to deactivate at a certain date/time?
-
Multifamily Unit Turn Management Template
Good afternoon, Does anyone have (and if so are you willing to share) a template for keeping track of unit turns at an apartment complex? Thanks!
-
Does Smartsheet have voting buttons for "voting up" ideas?
Looking for an interactive way to vote, like Tricider or Stickymoose, but within Smartsheet. Thanks!
-
User-submitted forms: Is there a way to have email address and name be automatically added to my Con
I have an "Update Request" Smartsheet, where employees can submit a request via a form. The 'name' and 'email' fields are both required, so I'm capturing those fields on every submission. BUT even though someone enters an email address and name, I still have to manually add that person to my Contacts. How can I set my form…
-
Check Box and Conditional Formatting
Hello, was hoping to get some advice ... i have a long drawn out conditional formatting expression that will turn a row a certain color once it is all met .. at that point i want a box to automatically be checked to indicate that the expression has been meet and something is ready to send .. i was looking into if formulas…
-
Webform send automatically
Hi, is there a way to send a webform automatically. https://app.smartsheet.com/b/form?ffff&Element=123 will set the Field "Element" with 123. Maybe it's possible to send somthing like &Submit=True or so. For what: I will sign my elements with QR Code and want the employees to scan the Code with nothing else to do. Date of…
-
Can input from two different Forms be fed into One Sheet?
I understand that a form can add new rows and data into a sheet. But what if I want data from another form to be pulled in. For example, data on the names of an employee, start date, salary, etc. will be pulled from a New Employee form. But I then also want to pull in data from a Survey from their Manager on their…
-
Change Control Automation for I.T.
I would like to create and automatic a change control process for I.T. As the VP MIS I want workflow with control criterias build in based on the change requested. E.G. if its a level 1 or a critical system or downtime etc. It would come to me. E.g. if it's an update or level 2. I can go to my I.T. manager. Is that posible…