-
Convert multiple text dates to a date field in a single cell
I have contract information entered into my sheet via Web Form. The users are allowed to enter multiple products in at once but asked to keep information pertaining to them in the same sequential order throughout the form entry. I am looking to see if it’s possible to take multiple text dates entered in a single cell and…
-
Can I have the default value be a function?
I have a form that asks for someone's name. Most of the time, the form is for that person. There are some cases where a person might fill out the form on behalf of someone else. What I'd like to do is have a "name" field and a "on behalf of" field. If "on behalf of" is blank, I'd like it to default to the value of "name".…
-
Web forms, is it better to add at top or bottom
I have been using web forms to populate existing sheets with new data. But I have a question as to whether it is better to have new data at the top of the sheet or the bottom? 1. I see that updates are referenced by row number, so if I have data come in and an update request is sent out. And then new data is added at the…
-
Resource Check Out
Hello, We are trying to use a Smartsheet form for check out equipment from a drop-down list. Is there any way for the Form to not display an item is available for check out(I.E. remove it dynamically from the dropdown list) if it was checked out by a different staff member? regards, Brian
-
Create a Form with dynamic fields
Hi, There is a way where we can create a form and in this form we can duplicate a set of field as much as we need? Currently, I am calling a form and at the submission, I am redirecting to another form, and on submission, I am redirecting to the same report. Could we have this in 1 form only? Thank you.
-
Turning a Paper Report into Smartsheets
Greetings, While I appreciate consultants, I'm not currently seeking to hire anyone to do this for me, I just have general questions to accomplish my goals. My direct supervisor sends out a request for certain data to various people on his staff once a month. It's a "Service Report" of sorts that is used to provide data to…
-
Forms with multiple levels
Hello, I'm hoping for some advice on how to create a form with multiple levels. By levels, I mean that some of the information submitted on the form will stay the same and can span many line items on my grid. That would be one level, and the second level would be additional information that would be different per each line…
-
Additional Approvals
I am trying to set up an additional approval process. For example, one manager will approve X and the second manager will approve on certain conditions based on a column, based on the notification of the approval from X. How can I set this up. Basically, having 2 approvals in a workflow.
-
Embedding a form into Dashboard
I am currently overhauling PTO dashboards for my company. Each dashboard has a link for an individual's sheet that records time off and the related request off form. Is there a way to embed a single form to the dashboard and have it link to individual's sheets instead of 15 different links?
