In our team project trackers, we are leveraging worksheets with grandparent/parent/child relationships to organize by the the different business/clients/projects. Our desired automated reporting outpu…
Hi! I have a Original sheet with data being inputted by different users and locations. I was trying to build out reporting so I moved one locations data to another sheet. Is there any way to move it b…
Hello! I have reviewed Smartsheet Discussions quite a bit, but this is my first post. I am trying to correct a formula I made to change RYGB statuses. Currently the status correctly changes based on t…
Hello everyone - thank you for your help. I am having some challenges with an Index/Match formula that populates a Contact List type column from a cross-sheet reference. It is finding the data & pulli…
I was wondering if there is a way to get the sheet Id of a specific sheet using the name of the sheet. Get sheet accepts the sheet id to get the sheet info, but I would like to get the sheet using the…
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…