My team is looking to lock a cell so that only admin's and owners can edit the column, but we need our other team members with Editor permissions to be able to at least copy and paste the cell and hav…
We have 2 columns. 1) % completion 2) Status (not started, in progress, completed, significant delay, etc). We would like that every time we move % Completion from 0 to any number up to 100, Status ge…
I would like to view rows grouped by their category (from a dropdown column) in Sheet form, so that I can add new rows while viewing my data in an easier-to-read format. Currently it seems grouping ca…
Hello, I have a sheet that contains people and scores (1-100) based on their performance. I want to create a table to show the top 10 and the bottom 10 people based on their score. Any ideas on how to…
Here is the use case: Smartsheet A: Lists selected clients once per row (includes a column with a unique client ID). I created a drop-down column for each product with yes or no picklist. Smartsheet B…
Hello, My name is Caylee Birkel; we have a cabinet design company in Nebraska that uses Business Smartsheet everyday and need help taking our Smartsheet needs to the next level. We don't want to upgra…
Hi All! I have multiple sheets that are tied to specific team members on my team. Each sheet has the same columns. I'm currently trying to see if there's a better way to organize this data. Right now,…
First time posting a question, fairly new to smartsheet. I have a spreadsheet in googlesheets that does what I need, but as we are moving over to smartsheet with a lot of our other work, I would like …
Hello Not sure how to navigate this one. I am receiving form responses when people fill in a web form... but the sheet that it relates to is not in Smartsheet. I think it may have been deleted previou…
Example I have 10 sheets for each client and converted those into reports to get the information in one place. Now to feed the details like count/avg/pivot/sum on dashboard I should convert the report…