-
How to start time on a project and prompt for a list of tasks
Hello. Our Implementation Team is asking for a timer of sorts to capture their task time (whether onsite at clients or remote support). At the beginning of work on a specific day, the Implementation Tech would hit a start time button, then - they will work on their assigned tasks that are listed in our Smartsheet project…
-
ad sheet to report automatically
i have a folder under "sheets" that has all my ongoing project. i made a few reports that sum up info from all sheets my problem is that every time i add a sheet to the folder i need to manually add it to all my reports how can i make it that every sheet i add to that folder will automatically be added to a report?
-
Forms to Smartsheet Workflow
Hi, I'm trying to create a Smartsheet Form that collects issues relating to 4 different locations. In the Sheet, I have four different Rows associated with each location, that are the top of the task hierarchy. Within the forms there is a field to choose one of said locations. What I would like to happen is, when you input…
-
Form logic decision based on greater than or less than comparison?
I have a text/number field that I'd like implement some form logic to show another field if the value is 2.0 or greater. I have added number validation, but the logic options don't appear to give me an option for greater or less than. I then thought that I might create a quick formula column that would result in "Yes" or…
-
Autopopulate Fields from existing columns into a Form
Hi all, I am trying to autopopulate two fields into my form from two existing columns with data. I've been following the community and so far I am able to pull one field using this formula: ="Linktotheform............?NameandSurname=" + SUBSTITUTE(NameandSurname@row, " ", "%20") Like that it works perfectly and I am able…
-
Any plans to allow more than one upload field on a form?
Multiple upload fields would be helpful when specific documents are required to make a form submission complete. Right now, we have to list all the required documents and hope the user will read and follow the directions. Even if we require the field, they will only get an error message if they don't upload anything. (But…
-
How can I stop my Sheet Summary from changing the location of a cell when form data comes in?
I am creating an inventory form that populates data into a sheet on "Top of Sheet". I want to create a summary sheet that reflects how much of an item we need vs what we have entered on the count (via the form). My issue is, whenever a form gets filled out, it also shifts the cell I am trying to reference down. I want it…
-
Why can't I update a row with a Form?
I'd like to allow users to update information in a row via a Form. I like the user interface of the Forms and would prefer to keep users away from the spreadsheet. I know about locking information in the spreadsheet and that is not what I want to do. Our spreadsheet has a large number of columns and I want the user…
-
Employee Fit Testing Tracking
I am very new to creating my own smart sheets, I am looking to create a tracking of Employee Respirator Fit Testing. This sheet would need a away to annually updated by testing completion date as well as the type of mask they tested on, noting that some employees with have to complete fit testing on multiple masks each of…
-
Form value of 1 in percentage column captured as 1% not 100%
I have a form that captures data in a column with percentage formatting applied. If a decimal value is selected such as .5 the data is properly captured in the sheet at 50%, but if 1 is selected it is captured ad 1%, not 100%. I've tried to change the value to 1.0 and 1 and the behavior is the same. In the sheet itself if…
