-
Grid help needed to reference different POs with changing totals?
Greetings- I created a SS for my finance dept. Basic form where they can select a vendor from a drop down menu and enter that month's bill with what they paid. Each vendor has a different PO number with a different total amount on that particular PO (purchase order). Im having trouble figuring out how to start with a PO…
-
Set Uniform Column Widths
Excel has a feature where you can select multiple columns at once and then right click to set a specific column width. I would love to see a feature in Smartsheet that allows this as well - especially in a sheet with a lot of columns, it is frustrating to have to go through and individually modify the width of each one,…
-
Dynamic view updates are not displaying in my dashboard report, how to fix?
We use a dashboard to display different reports for tracking program progress. I have my current dashboard set up to display a report that pulls from a grid. When the user clicks on the report display, it opens the dynamic view of the grid, where they can make updates using the panel. The updates to the dynamic view are…
-
"Show More" option for cells with long wrapped text
Request: When cells have long wrapped text that have more than 3 (or 5...) lines, truncate the rest and provide a "show more..." link to expand the rest of the text. This will greatly compress sheets and rows that contain longer text. Example: goes to Comments: I am aware that I do not need to wrap text, and that will…
-
Sorting by Due Date?
Hello, I am looking to build a task tracker which automatically orders tasks by due date. Entries will likely be made via form. It's my understanding that items on a Smartsheet grid need to be manually sorted each time new entries are added. Is there any way to work around this to enable automatic sorting by due date?
-
Automatic WBS Numbering
We have a work around but it takes multiple helper columns and complex formulas. You need WBS numbering 1 1.1 1.1.1
-
'Assigned to' names & tasks not showing up from in Card View
Hello, I am having an issue getting the names from the assigned and assigned to columns from GRID VIEW to automatically populate into the swim lanes when switched to CARD VIEW. Currently, I have to manually edit the lanes and add the names. My manager said that when she switches to card view from grid view, the names…
-
Print grid view on a Published Link
Hi community! I'm having issue with the print button not working on a Published Link (Grid View). The printer icon is there, but when it's pressed it does nothing. Do I need to enable anything to allow that? I'm using Mac OS 13.4 / Chrome 114.0.5735.133. Thanks! Derek
-
Assign Contacts to Child Rows Based on Criteria in Parent Row
We have multiple stages in our projects that are set up with a parent row and then child rows below. I would like to assign a contact to the parent row of a stage and have that contact automatically assign to all child rows below. Is there a way this can be done without add-on software?
-
Auto-numbering automation
Hello I have a sheet, that uses numerical ranks to keep track of projects. These ranks are simple number assignments (i.e: 1, 1.1, 1.2, 2, etc.), that we use to determine the priority of the project. If a project changes priority, or we have a new project that comes in at a high priority we have to manually update the…