-
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…
-
Alert Someone Notification Failing
Good afternoon, I created a sheet that includes an automation to "alert someone". It is configured to send an email to two distribution lists at 8am when the date is 1 day before the date of the column "Date Arriving" in this sheet. The automation works perfectly when using my Smartsheet login's email as the one being…
-
Hello! How can I work an OR statement into this formula? I need it to look at 6 different columns.
=IFERROR(INDEX(COLLECT({Provider being reviewed}, {MRN 1}, CONTAINS(@cell, MRN@row)), 1), "")
-
Using the Copy Rows Function Within A project Template of Sheets
I am having an issue when I am trying to move a row of data to another sheet within the folder structure of a Workspace. When saving the workspace as a new workspace (for a new project for example), the sheet containing the automation to copy the row to another sheet continues to point to the original sheet, and not the…
-
workspace activity log
view changes that are being made in a workspace, like track new sheets made, who made them at what time, deleted sheets and dashboards, etc. short story behind the idea: a colleague wants to know if there is a way to notify others/themselves if a new sheets were made/added. If only we can make a sheet dedicated to show all…