-
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?
-
Reports
My company currently uses Device Magic Forms to do daily reports for people to communicate from the field to the office. We then have to take what's on those forms & re-input that information into Smartsheet to track our projects. This is a time suck on our company, so we are trying to directly have all of this on…
-
Multiple Attachment Fields on one Form?
Hello, Are you able to have multiple attachment/file upload fields on one form? I am looking to collect two different pieces of information and want to make sure both are required. I know you can upload multiple documents on the one field. Thank you!
-
Date Dependency in a Form
Hello, I have a form setup for vacation requests and tracking purposes. In the form the requestor has to input todays date, which automatically defualts to today's date, but we're having issues with the start and end dates. I would like default date to be dependent and automatically to at least update to the start date to…
-
View Cell History
How can I view the user who updated a cell? Even though somebody is signed in, the user name is always showing "Form User"? Thank you
