-
Adjusted Dates Based on the Time a Form is Completed
I am looking to have my automatically set due dates for projects adjust if a request is put in after a certain time of day via the Smartsheet web form. Currently I have a date column where I add a certain number of work days to the timestamp depending on the department that submitted the request that acts as a due date for…
-
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…