-
Update Okta SCIM Connector to Deactivate instead of Delete SmartSheet Users
Currently, when integrating SmartSheet with Okta and leveraging SCIM provisioning, the "Deactivate Users" feature on the Okta side will Delete the user's SmartSheet account, even if they are licensed and own sheets. This is problematic for automation purposes and results in pain from both security & user experience…
-
Moved: COUNTIF reference not working
This discussion has been moved.
-
Calaulate activity health based on % complete and Planned Finish date
In my sheet I have a column "% Complete" and "Planned FInish". Is it possible to create a formula which can highlight the row color in red, blue or green or yellow if % complete is less then 100% and planned finish is over a certain date (example 10 Dec 2024). I am new at smartsheet, need help from our community.
-
Upload -Data Shuttle
I have follow all the step in setting up the data shuttle upload and do only for 1 mapping buts when I want to Name the workflow it give the error-One or more of your sheet columns names are using the same name. Update the sheet columns in the mapping to only use unique names.
-
Workspace Panel Auto-Opening
I know this topic has been addressed previously and was resolved but is now happening again. Is there a way to disable or remove the workspace panel from auto-opening each time you open a sheet? It's extremely frustrating!
-
Workspace Panel
This has just started happening in our company and is quite annoying for a bunch of our employees. Is there a way to stop it from opening every time our employees open a dashboard, sheet or report? It is just extra annoying clicks all day long! Thanks in advance
-
Can the auto-numbering function be set up to utilize new numbering prefix at start of each year?
I created a sheet that uses auto-numbering to assign a number to all submitted forms. I want the numbering to utilize a prefix denoting the year and start over at 0 each year. For example the numbering of the submissions in year 2021 will start with 2021-01 continuing with 2021-02, 2021-03, etc. When the year 2022 is…
-
Trying to use average formula of the DURATION with multiple criterias in the same sheet
I want to check a Lead time AVR for on the Duration Collum for only specific STATUS :Pending Marsh, Pending Lockton, Pending Lockton and Marsh and Pending LL I tried below formulas but are not working at all. =AVERAGEIF([Status]:[Status], OR([Status]@row = "Pending LL", [Status]@row = "Pending Lockton and Marsh",…
-
How can I get horizontal tick marks in dashboard graphics to show?
Graphs have Horizontal Tick Marks but they only show when a graph is in edit mode (red arrows). They all have show tick marks checked for horizontal. The middle chart on the bottom is the one that is being edited. How can I get the tick marks to show when it's live?
-
Auto Number Formula Help - Add Project Code as Prefix
Hello, Is there a way to create an auto-number system to show [Project Code]-P-[AutoNum] where the auto number references the project code in the same row? Here's an example to illustrate: But when I try to add this prefix system to the Auto Number column properties… [Project Code]-P- types it literally… "[Project…
