-
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…
-
Report not letting me input data
I have created a report however i cannot seem to edit any of the data in the report sheet, they are not locked columns and are made so people can free type in one of the columns and in the other column they can choose from a dropdown menu... these work on the base sheet however I cannot input or choose anything on the…
-
Importing Excel Sheets with columns that have a Menu Selection
I have an excel sheet with imbedded menu options (Yes, No...etc multiple types of selections) in several columns, is there a way to import those menu items. I am only getting the basic cells, there are no formulas to import but critical that I get all these multiple menu items pulled in. Please advise and thanks.
