-
Workflow Approval Options
It seems that a workflow approval should have 3 options. * Send serially to approver then to another approver. * Send to more than one approver at the same time and if ANY approve, it moves to the next step. * Send to more than one approver at the same time and only if ALL approve, it moves to the next step. I cannot seem…
-
Trouble with Calendar App Group Data
Hi! I am having trouble with the Group Data By function and using the Custom Category List Order. Some columns that I sort by allow me to choose custom colors while others do not. Is there a reason why some columns allow sorting by color and others do not? How can I identify which columns will allow sorting by color?…
-
"Unexpected Error" message when submitting forms
I have a user that continuously gets an error message when submitting a form. I have multiple users on this sheet, myself included, and have no issues submitting. He was using the link that I saved to his desktop, but even if he goes straight to forms from the sheet it either won't load for him or he gets the error…
-
INVALID OPERATION in one column but not the other
Hello, I have the below formula in three columns in my sheet. They are all referencing the same master sheet, same dates, same facility, same units, but different utilization rates. Two of the three columns are working great. The last one isn't. I re-typed the formula in several times, following the other columns' formula,…
-
How to count how many users assigned to in a sheet
Hello, I have multiple projects and each project is in its own sheet. I am trying to create a summary sheet (to later show in the dashboard) that shows how many people are assigned to each project currently. Is there a formula for this or a feature? Thanks
-
Unhide row
I need to retrieve a row in a master smartsheet. I can see that row in a report output, but cannot see it in the source sheet. In the master sheet row number jumps from 266 to 268 and it's 267 that I need. On the other hand, you can't hide, and therefore unhide rows as such, the only thing I can think of is that I may have…
-
Report Building Criteria
I am trying to build reports that segment my data into 5 different reports. One for each year 2019, 2020, 2021, 2022, and 2023. When I select the GLY (Go Live Year) with any on the aforementioned years, my reports come back blank. However, when I select a different criteria and then add the GLY as an additional column, the…
-
Need some helps on Workflow
Would like to include multi stages approval in my workflow. How can I tie up the approval process with the amount of purchase? For example: is less than $500 only one approval, if between 501 and 2,000 then I need two approvals. How do I set it up in the workflow? The amount of purchase is a single column in my sheet.…
-
Global Updates - Add new column doesn't display the projects
I created new Columns inside a template and wanted to push these out to live projects using Global Update. When I select "Apply Test" then none of the project [Templates] appear 1. I have already done this once before and the projects did appear at that stage. 2. I have also tried another type of Global Update Update…
-
Creating a Simple Data Entry Screen and Ability to Search and Display Data Entered in the Past
I'm just starting to look at SmartSheet... does anyone know how easy it would be to create a simple data entry screen (maybe 15 fields) and save the data in such a way that it would be easy for others to search through the data that has already been entered? It's not exactly my use case, but an example would be a simple…
