-
Smartsheet Automation Run Workflow Option Not Available for Hourly, Daily or Weekly
I am using the Automation Template "Copy a row to another sheet when specified criteria are met". Can this be enabled and enhanced? Below is what I am looking for. A) Minute and # of Minutes (e.g., Run Workflow every 10 minutes) B) Hour and # of Hours (e.g., Run Workflow every 2 hours)
-
Add days to a date. Formula help
This discussion was created from comments split from: Can't add days to a Date.
-
How do I get Working Days remaining to stop counting once a task is complete?
I'm using a SS template that has start/end date, working days remaining, duration, % complete and status. If I mark a task 100%, it automatically changes my status to "Complete". It's a nice little automation. What I'm noticing though is that the working days remaining field continues to count and I have a "-" (negative)…
-
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?