-
Recurring form submission error
We continue to see this error in forms connected to a specific sheet, even when all inputs are given, required or not: The information you entered is incomplete or invalid. We have 4 identical forms, except one value in a hidden field. The error has occurred in several of the forms since we created them six months ago.…
-
Merging columns from 2 sheets that are filtering through to 1 report
Hi there, I was wondering if someone can please help. I have created a report on smartsheets. Two separate sheets flow through to this report. Both the "Branch/Department" columns flow through to the report but I don't want to have two columns that are "Branch/Department" , to make it simple is there any way of being able…
-
Filtering values on Graph
In the graph shown below, i need graph to be displayed only for which has values (Test 2 and Test 4) and graph which has 0 value should not display names (Test1 and Test3). This graph data is pulled by source sheet, where team member updates source sheet on weekly basis. There is a chance, where Test 1 and Test 2 will have…
-
How do you move a row from one month group to another?
I am using a 12-month calendar template. I have content in one row for May, but need to move it to June. I know I can copy and past but this leaves behind the comments, files, and proofs. I have tried sorting in various ways and it does not seem to work. Do I have to change the formula? Or is there some kind of a way where…
-
Calender View
Hey smartsheet community, I have a question regarding the calendar view or maybe calendar app: Is there a possibility to show more than just one date or range. I know the following setting but I want to display more than just the "Transition to BU Date". Is there a chance to do that and in the best case to combine it with…
-
Ongoing Performance Evaluation Setup Dashboard - Form Won't Populate
Hi - I was asked to set up this dashboard: The template has been downloaded and the new workspace has been created. The form is set up, and when I did a test fill out of the form, the data went to the "Feedback: Positive" report, (which populated onto the feedback portion of the dashboard) but the data won't populate to…
-
Smartsheet reports created from 1 sheet for updating, need to allow users to set their own filters
Hi, I have a Master Smartsheet, that I created 20 reports from. Each report is a filter for each user and shows just the columns that need to be updated. As we add add more data by phase in the master sheet, each user wants to filter the data by phase as they are working through their tasks. Edit permission does not allow…
-
Send to Contact in a Cell Limitation
Is there a limitation as to the number of email address that can be entered into this workflow? I have an alert that I want sent to 3 different email fields within the Smartsheet. However, the automation tool is only displaying 2 of the 3 potential "Conacts in a cell."
-
10000 cell (combined) reference limit
Community, I'm getting the "10000 cell (combined) reference limit" in a grid file and cannot overcome it. My situation: I have 5 master files with approx 14,000 lines of data using =count to simply pull the number of lines in each file and summing those for a total using a single range in one column in each of the 5 files…
-
Can I trigger an automation based on the completion of an update request?
I currently have a workflow in place which allows for both approval requests and update requests, but at two stages of the process, the approval request and update request fire off at the same time. The correct order would be for the approval request to process when the update request is complete. I have thought of adding…
