-
Select a specific row for a SmartSheet dashboard or chart?
We run an architecture review board where we score along 12 measures.Each row in our grid represents one review, and the scores for that review are recorded in 12 columns. I'd like to create a dashboard or chart where I can choose a row and the dashboard will update to show the scores for that review. Is this possible?
-
Is there a way to change the highlighting color when using the FIND functionality?
Currently when we use "FIND" on a page, it highlights the cell in the found results in white? They can be a little hard to find on a sheet. Is there a way to change the color it uses to highlight the cell? Or can it highlight the word or change the text color on that word? Thanks!
-
Tracking Created/ Modified and retaining historical data
Hello, I am managing a RAID log which was previously copied from Teams and past into Smartsheet. I'd like to track who and when: created a row modified a row I know those can be automated easily by system columns, however there are some historical data i the already existing columns (creator , created on & modifier,…
-
Task Details Alternative?
We're switching over from Asana where you can click into a task to see more details - this seems to be a basic function of every other PM tool platform. Smartsheet seems to be missing that. It looks like the only options are to add another column to serve as the home for task details - this feels clunky because if the…
-
Sheet owner assigned 'Editor' but it shows 'View Only'
I have a sheet with Collaborator but only the owner can edit. Permission is set to admin on collaborator, but it shows as 'View Only'
-
How do I not report on parent row tasks from a project plan?
I created a project plan where I created (for example) a parent row of "Day 1 Comms", and then created 2 children rows ("Develop comms" and "Approval of comms"). I assigned the 2 children row tasks to "Marketing" and added start and end dates that were in the past. I created a report to see all "overdue tasks by dept"…
-
Calendar Time (Hour/Minutes)?
Good Afternoon SmartSheet, Does SmartSheet support Hours / Minutes within Calendars? The reason I am asking.. I have both a PTO and Scheduling sheets right now that currently have a Calendar setup on them where people can request a date to work/off from work. However it shows them for the entire day. But, I also have Part…
-
Is there a way to crate a custom sort order on reports?
I have a report that includes a "Priority" column (single select - Critical, High, Medium, or Low). When I use the sorting function in the sheet, I think it sorts in the order of the list that I typed in the column properties. However, when you're in a report, the sorting only allows for ascending or descending…
-
Dependencies- Start and End Date help
I am trying to automate the start and end date of Task #2 from Task #1. I have enabled dependencies in Smartsheet. Here is the order of events- A deal closes on 9/29 (task #1/row #1), and then I need to do a knowledge transfer for 4 days from 9/30-10/3 (task #2/row #2) For example: Under the "Predecessor" column on row #2,…
-
Need help with a formula!
Hi community, I could use help with a formula. I have a sheet that has all of our Claims data (types, dates, etc) and then a separate sheet that identifies the different claim fees per type of claim. I am trying to have each claim reference the Per Claim Fees sheet to take the type of claim (Auto, Workers Comp, General…