-
Max number pulled from the ID
Hi all, I am looking for help with creating a formula which would give me the max number (based on condition) from combined ID? Example of ID's RTR_I_053 TPM_I_012 FTS_F_009 The condition would be if the ID contains example "_F_", give me the highest number for this item. I tried =IF({Ref to ID column}, CONTAINS("_F_",…
-
Value labels on charts - font size and location adjustment
The current formatting of value labels on charts shown in a Dashboard is very clunky. The current positioning above the data segment can be confusing as overlays others. The size of the font can also look unprofessional when redu cing the size of the chart on the dashboard. Can we have the ability to change the size, type…
-
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…
-
How to determine the workspace ID & Name and folder name if I only have the sheetID?
Hi, I am using the Smartsheet API for Python. I can determine the workspace names and IDs. I can determine the Sheet name and ID. However, I need to know which workspace (ID & Name) and under which folder of that workspace a specific sheet (per sheetID) resides. How do I do that using python, please? Thank you.
-
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…