Discussion List
Pivot App creating unwanted columns filled with 0's
I am baffled by the behavior of one of our Pivot tables. When we run the pivot, we receive unexplained columns filled with 0's. Here's the source report, a report of outstanding tasks and their End Months: We used the Pivot app to view the End Month as columns and this is the result: The problem is the first column: "2023…
Shortcut & Hyperlink accessible to Non Smartsheet users
Creating Dashboard, Sheet to centralized all links to other sheet in a Workspace. I need non Smartsheet user to easily navigate from sheet to sheet to collect data from them. My tasks: Creating Workspace out of a template. Publish sheet Insert hyperlink to freshly created sheet/Dashboard Share Master sheet to non…
Smartsheet Automation Waterfall
It would be great if Smartsheet Automation can have the ability where the Action initiates another Automation whether it is within the same Primary Object Automation or Foreign Object Automation.
Smartsheet Automation Last Conditional Path Allows Smart Continuous Loop
I have a Smartsheet Form for a Quiz. Each Question is a Column with Column Type = Dropdown List restricted to the selection availability. For each Question (Column), there is a 1:1 relationship assignment of Automation Template "Change a cell value when specified criteria are met" which assigns 10 points for correct…
Can I auto add new users to a specific Workspace and access to the underlying sheets
There are a number of posts about this but they're several years old and answering my specific question
Flagging Duplicates with Multiple Criteria
Hi all, Trying to identify when I get a duplicate that meets both criteria, when the Work Order Number is the same and when the Service Area is the same. I'm using the following formula, =IF(COUNTIFS([Pass Number]:[Pass Number],[Pass Number]@row,Site:Site,Site@row)>1,"Duplicate","Not Duplicate") But its not working…
Smartsheet User Training
How are you managing keeping track of training status of the users in your plan? I have seen some training templates but that would still require reliance on the user informing the admin of their training completion in Smartsheet University. Are there other alternatives?
Barber pole and crosshatched backgrounds
Would like to see the addition of barber pole and crosshatched variations to background formatting. This would be beneficial in visibility in conditional formatting for say TBD and Blocked items.
Resource Management - Way to Pull From Project's Metadata?
My team is looking into purchasing the resource management add-on and we are looking to create custom fields in the project to pull data from the metadata of a project. Is there a way to do this? I can create the custom fields in the blueprint but it doesn't seem to be connecting to anything so I have to manually input the…
Smartsheet Automation Not Registering Column Type Dropdown List with Option Character length = 128
I noticed that if I have a Column Type = Dropdown List with an Option = 128 length of standard alphabet characters, then the Automation template for "Change a cell value when specified criteria are met" does not recognize that option when assigning a Condition off that Option. As soon as I redesigned the Option = 17 length…