-
Is there a way to save and recall sheet layout (i.e. column visibility, order, width, etc.)
I provide updates to different groups in PDF and Excel format. Not all columns are visible to all groups, and they aren't always in the same order for all groups. I'm wasting more time than I would like unhiding and re-hiding specific columns, dragging the columns into the right order, and then setting the column widths,…
-
Update request to assigned team member
Is there a way to automate who the update request goes to. Currently every time I click update request I have to fill in the name which is time consuming especially if I have different team members assigned to different tasks. I saw this question was answered as no in 2019. I'm hoping this has been added? Thank you.
-
How do I sort the data in a chart?
I have multiple charts created in a dashboard based on data in a Sheet. I don't see an option to sort each chart in ascending/descending order. It's in whatever order the data appears in the Sheet. If I sort in the Sheet, it fixes one set of charts I have, but ruins another. There should be an option in the Dashboard Chart…
-
Dependency duration not displaying correctly. Start-to-Finish Issue.
Hi, I'm using dependencies to create timelines for projects where I type in a launch date and then all the previous rows fill in accordingly as a work back schedule. This feature used to work great, but I noticed last week that now if I have a duration of 1 day, my start and end dates span 2 days instead of 1. I set my…
-
Conditional formatting for error values
Hi, I'm using VLOOKUP for status information from another table. The referenced table sometimes does not have the requested row, so I get back the #NO MATCH error. This does not looks nice, so I was trying to hide from the users and set conditional formatting - if column value equals to #NO MATCH set the font foreground…
-
Multi-Sheet Cap for Reports/Pivots/Dashboards
Good morning, I need to report on data spread over 50+ sheets that are updated independently. The plan had been to place all these sheets in a single workspace and run a Dashboard or a Pivot referencing them all, but I cannot find whether there is a limit on the number of sheets a single Dashboard or Pivot can reference.…
-
Anyone use Smartsheet for tracking legislation?
I work for a state government agency, and this year we are developing a workspace to help the department track bills of interest/impact as they make their way through our state legislature when the next legislative session opens in January. Does anyone have any examples of what they use for something like this?
-
Create a report from multiple sheet but with row as Columns
hi Friends, I am trying to make my Smartsheet work better for my user. the problem that I am facing id the following My Workspace is build in the following way. Each of our project have a specific folder name let say Project1 , Project 2, Project 3 In each of that folder we have many many files, one of them there is a…
-
How to overlay Team Vacation Planner into my Project Plan?
Hi, I have 2 separate spreadsheets, a Project Plan and a Team Vacation Planner. Is there anyway I can incorporate the Team Vacation Planner with all the team members holidays into the Project Plan without having to retype all the holiday dates into the project plan? Plus, anytime the Team vacation planner changed, this…
-
Issue sorting rows
Looking to understand what could be causing an issue with my row sorting. It seems to have sorted the 1st half of rows and then starts a-z sorting again later on in the sheet. Is this because someone else is using a shared filter? And if so, how do I get round this?
