-
Looking for a way to auto fill the Label and Description on a form
Is there a way to quickly customize label and descriptions on forms? Like for example reference the field that contains the label and description information so it populates based on the primary value. Example I'm using the form as a voting ballot for prioritizing issues. The primary key is the Issue number then there is a…
-
'Report' on Survey Results: How do I have a 'secondary level of Count'?
Hi Smartsheet Community! I'm trying to generate a 'Report' based on a survey of global respondents divided by 3 Regions, and the distribution of the Rating Value both globally and by Region: I got the count of Survey responses in Total and by Region 😃 (see image below) Now, I would like to get secondary level of the count…
-
Track if a Request Update form has been submitted
Is there a way to check if the request update form has been submitted. I need this because there is no way to make fields mandatory in request update form. So it is difficult to trigger another workflow based on fields in an update form where they could be left blank. I want to check if I can trigger another workflow based…
-
Report - Summarize Count Function is not Offering a Column to Select
I created a report from a sheet in which I want to use the summarize count function in the report to count the number of tasks in the report. When I go to Summarize, it does not offer me a column to summarize to count. Screen shot below:
-
Incorrect results extracting date from system Created (Date) column
I have a system column of Created (Date). This is [Snapshot Date/Time] in the screenshot below. I need another column that should reflect the DATE part of the system column. I am getting unexpected results in the date-only column. In the attached screenshot - you can see for both 4/21 and 4/22, the formula returns 4/22.…
-
Free Training
Hello, We would like deploy Smartsheet on our site. We would like have a free training for the basics. The last link is delete Thanks to share a new please
-
Smartsheet Forms - Displaying View Only Fields
We have a SS Form that we are using to collect Project Go-Live Confidence for that month. The Form provides the PM with the Project Mgr Name, Project Name and Current Go-Live Date along with conditional questions. We want some of those fields to be View Only on the Form (PM, Project Nm and Curr Go-Live Date). I haven't…
-
Stack Chart
I am trying to create a stack chart based on counts of multiple columns. For example I have a column titled "Quarter" that is a dropdown list which could contain Q1, Q2, Q3, Q4 or Next Year. I have a second column titled "Status" with a dropdown list of Red, Yellow, Green, Blue. Red means not started, Yellow mean Scoping,…
-
Using COUNTIFS to automatically assign new rows to a person based off criteria
Hey all, I am working on a way to automatically assign newly added rows to a sheet based off a certain criteria. We have two managers. I'd like new rows to automatically assign to one manager then the other based off different scopes of work from a multi-select column. For example, I can only input 8 types of jobs and 8…
-
One Row - Multiple Actions with Different Owners
Is it possible to have one row, with multiple actions where the automation only goes to the appropriate action owner? For example, we do an intake of information (let's say IT issues) and with every IT issue there are actions identified and a corresponding action owner for each action. However, we don't want people to have…