-
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 you cell-link within the same sheet?
My team is tracking product development for a project and we want to be able to reference multiple rows within the same sheet. For example, in row 20 we want to have a column labelled "Refer To" and then in the cell, have a link that takes the user to row 100, 140, or 170. I know you can cell-link to other sheets in a…
-
Text Wrapping is not working.
Hi, I've created a new sheet and a form, I've applied text wrap to the columns that might need it and I've tested certain cells, inputting more text than the cell than would be visible. I've clicked an unclicked the text wrap button on the menu... nothing is happening. I've saved and refreshed the sheet...still no text…
-
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.
-
Custom Colors for Sheets
While it is wonderful that we now have the ability for custom colors on Dashboards, it would be truly helpful to also have this same ability in Sheets. It would be really helpful for some of our projects because our district uses certain colors to call attention to various district initiatives or our district instructional…
-
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"…