-
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…
-
number of days between one state and another (not including weekends)
I need to include a column that shows me the number of days that a person maintains each state (not including weekends), if you don't enter the form every day to update the information. Could someone help me with this? date of creation| Name | Status | DAYS WITH THAT STATUS 03/03/2018 | cristian | busy | 1 02/27/2018 |…
-
Forms-static data on forms
I have a sheet with a list of forms that need reviewed. I would like to create a form that ask questions about the form and collect that data on the sheet. Is there a way for the form name, which is in the primary column, to populate on the form and not be editable?
