-
Viewer +Forms
Can a only "viewer" fill out a Form made that will edit the smartsheet? But won't be able to mess with the data collected?
-
View form submissions in form format rather than sheet
Hello, I have an active form. The field descriptions built into the form are much more detailed than what can fit in the column titles due to character limits. Is there the functionality to view form submissions in the form format (rather than in the sheet)? In this case, requests go to a committee for review, so reviewing…
-
% Complete Report using boxes specific to create report
I use the Board Report Column as a filter only. More specifically, it allows me to filter only the items they want to see on their report. In addition, I need to provide them with a "% Complete" of only those items using based on the following: Not Applicable needs to be excluded, Not Started needs to be 0% and Complete…
-
Generating Workflow from One Worksheet to Activate Form on Second Worksheet
I have a Smartsheet designed to track the status of work in a business process. At the last step, I want to generate a workflow that will send a survey created in a second smartsheet to each participate. Is there are guide or information on how to set this up?
-
Forms
Do users need to be set as "editor cannot share" to be able to do a form? The form I have will collect data and add it to a smartsheet. I just don't want give people to much permission to be able to edit the data purposely or even accidentally. I just want the people to be able to do the form and nothing else?
-
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…
