Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Discussion List
Report showing different color than the row in the sheet
Hi - I have a report that I run that shows me all the line items from various sheets that are assigned to me. On the report is a column for "Sheet Name". When I run the report, all of the rows from one of my sheets looks the same - the value for Sheet Name shows with a white background and a blue link that I can click on…
Monthly Calendar View Exportable to a PDF?
Hi there, I have a large Smartsheet document that I would like to export to a PDF. While I can export it under the card view, regular view, and gantt chart view, I cannot export it with the monthly calendar view. Is it possible to export the monthly calendar view into a PDF or Excel sheet? Thank you!
Resourcing Allocations
I am trying to find a way to accurately reflect the resource capacity of an individual when assign multiple concurrent tasks in a single day. I appears that if I assign for example 8 one hour tasks (effort = 1h) that the person shows up at 800% capacity for that day rather than being at 100%. How can I make this work? Do I…
Auto-fill formulas for children rows
I click on the parent row that is below the children and insert a new row. This comes up as a child row for the above parent but the formulas that those children have do not autofill to the new row. Can this be changed?
SubTotal
Is there some way to use subtotal with filters like in Excel ?
Creating a group that includes everyone in my Enterprise Account
Is there a way to populate a group with everyone in my Enterprise Plan automatically? So every new user is added to group seemlessly? I would like to use this to be able to share sheets or workspaces with everyone in my company. Thanks for helping!
In the Card View, is it possible to remove the summary task from the Uncategorised swimlane?
Hi, I am just starting to work with Card View. One thing i observed is that the "Uncategorised" Swimlane has the tasks as well as the Summary Task. Is it possible to "hide" the Summary task from the uncategorised virew? It also becomes difficult to differentiate between a summary task and a task. thanks Robert.
Format hair line that indicates current date
We often use the Gantt chart on a projector. The dotted line which indicates today is then hard to see for attendees in the room. Is there a way to change the formatting of the line to make it stand out more?
Progress Bar in a Card View
How can I introduce a progress bar or Odometer in a Card View
Given two columns A&B, what formula would I use to pull a value from B that corresponds to the MAX(A
Given two columns A&B, what formula would I use to pull a value from B that corresponds to the MAX(A)?