-
ownership issues
Hello I am the new owner of a workspace containing several folders. One of my colleagues who has no paid account is experiencing issues. He was admin of the workspace before and is still admin now.He is listed as owner of some files but they are now read only to him -he gets the message of needing a paid plan. They also…
-
Duplicate records
I’m working with HR on getting employee onboarding, offboarding and status changes processes streamlined. Currently they are using separate smartsheets for onboarding, offboarding and employee status changes. Recently HR is planning to combining all three and put it into one sheet. They want HR to enter information using…
-
How to autofill a single cell when a new row is added?
Our team uses a sheet to track our projects. One of the columns in the sheet is an Award Status column with dropdown options. When a new row is added, I want the default to be set to Pending. How would I go about doing that?
-
How do I name an automated Workflow?
How do I name an automated Workflow?
-
Get values from a column with blanks insert into another column without blanks
I have a some projects on a sheet that all follow the same template. The ProjName column has the project name (duh) and is the only value in that column for each project. ProjName - Task - Date - Comment project 1 - - - - First task - 1/2/2021 - comment1 second Task - 2/1/2021 - comment2 project 3 First task - 1/2/2021 -…
-
Progress % in dashboard
I want to add a widget in my smartsheet that shows how close we are to hitting our target based on a summary total. For example, our target is 200 and the sum total from another sheet shows 100. I want a to show that we are 50% of our goal. Any Idea how I would do this?
-
Conditional cell locking/unlocking
Hi there, I saw an older article (2019) noting conditional field locking not possible but I figured I'd check in including a specific use case. Scenario: Employees belong to one of 8 labour groups however only 3 of the 8 allow a certain type of pension processing to take place. Column 1 is the employee name Column 2 is the…
-
Delete Baseline Columns
Hi, I'm having a hard time deleting the baseline columns, I've added screenshots below, but when I try to delete, I'm getting conflicting error messages, I can hide them, but ideally need to delete. Reading the support from the baseline page - it doesn't appear possible but hoping I'm wrong. Any help would be appreciated!…
-
Health Symbols issues
Hello, I created a Health column and would like to use green, red, and yellow symbols related to whether they are complete (green), in process over 10 days old, and in process under 10 days old. I used the following formula: =IF(Status@row = "Complete", "green", IF((TODAY() - [Ops Date IN]@row) > 10, "red", "yellow"))…
-
Forms - ability to add multiple fields
Hi, I've looked everywhere but cannot see if this is possible - or a work-around. I want to use the forms to collect information from site. One of the most import pieces of information is deliveries. So I have it set up so that "Materials" is a field/column, and then multiselect, and a second column for the quantity. This…