-
Link % completion and Status fields
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 gets automatically updated to "in progress". And when % completion hits 100%, then Status is "Completed" We will still want to…
-
Group Rows in Sheet, not just in Report
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 can only be achieved in a Report which does not allow me to add new rows. I am new to SmartSheet but have intermediate…
-
Ranking by score
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 do that? Regards,
-
Stop Predecessors from being deleted when a date is deleted
Sometimes we need to just delete the dates to start fresh or copy rows to use for another project, but deleting the dates also deletes the predecessors. I was trying to test a schedule template with many hours of work on defining the predecessors. When I wanted to blank out the dates again so it could be used as a blank…
-
Can I write a cross-sheet formula that works if one has one and the other has many?
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: Lists clients on many rows (includes a column with a unique client ID). I developed a formula to enter "Yes" IF the the…
-
Smartsheet Expert
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 upgrade our plan to anything higher than our existing plan. If you feel you can be of any assistance, we would love to hear from…
-
Column ID visible in Column Settings
The column ID has been removed from the Column Settings. It is now accessible only through Bridge. I would like to request that it be added back to the Column Settings.
-
Master Sheet with Thousands of Rows
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, 12 sheets are managed individually by each team member and then when a row is resolved, it gets moved to a "resolved"…
-
How do I sum cell values in a column up to a specific sum, and return the adjacent cell value?
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 to get this set up in smartsheet as well. We grow sweet corn, I have data that I use to make planting schedules and predict…
-
Form responses for a sheet that's no longer there....
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 previously by a member of the team who has moved on. Is there any way of either recovering this file (it's not in my deleted items…