-
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…
-
Best approach to automate users having their own individual checklist for testing?
I have a project where an individual tester (end user) will need to complete their own checklist for testing a process. Each individual is assigned a role, so whatever role they are assigned is the template that they will use to checkoff items as tasks are completed. As seen in the screenshot above, we have an example of…
-
Pulling data into a "master sheet"
Hello all, I am trying to pull select data from multiple sheets into one "master sheet", however I am struggling to find a working method. I am unable to use reports due to them not connecting with datashuttle. I have tried VLOOKUP, Copy Row automation, INDEX/MATCH and a few more but i can't get them to pull all of the…
-
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…
-
How to automatically add a "Date+2 days" formula to a cell when a new row is added?
In our request tracking database, currently if a Date Requested is "in the past" and another condition is not met, the entire row turns red to alert us of a new request. This is great, except that sometimes the request comes in after hours, and first thing the next morning the row is red. This gives our clients the…
-
How do I find an existing Workflow and remove it?
On this smartsheet sheet I know I have a Workflow that sends notification whenever a Row Changes. Now I want to delete it however I can't find the Workflow itself. If I select Automation --> Manage Workflows... --> I can't find that specific workflow. Anyone can help? Below screenshots
-
VLOOKUP separate sheets
I would like reference sheet A zip code with zip codes in Sheet B, and when there is a match change a specific column status in sheet B sheet B status
-
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…