-
Lock A Specific View (so users can't switch to another view)
We'd like the ability to restrict a view in a report or in a sheet so that a user can ONLY view a sheet or report in a specific view (like Card View, Grid View, etc.) Example: Our team discovered Card View is the safest way to allow multiple users to have Edit access to a sheet or report while lowering the chances of them…
-
Enable view selection dropdown in WorkApps
Currently it is not possible to switch between Grid, Gantt, Card and Calendar views for sheets and reports in WorkApps. There are numbers community questions about enabling (say) Gantt view for reports, or card view for both reports and sheets, so rather than address these ad hoc, I recommend the development team enable…
-
Merged: NEW FEATURE - Change View(s) in WorkApps
This discussion has been merged.
-
Apply conditional formatting (gantt) to parent row
Please consider developing the ability to apply conditional formatting to top level (parent) rows. It looks weird when everything below the parent is in color, but the parent is grayed out. Thanks!
-
Report builder - Collapse and Expand Rows
Hi, Is there a way to expand and collapse rows in the report builder just like the functionality that the sheets have? I want to be able to display in my project dashboard the same view that from the project sheet but unable to do so because I need to create it in the report builder first so I could display it in my…
-
Set Default View in a Shortcut Widget
When a shortcut widget in a dashboard is linked to a Smartsheet item, those links always default to the grid view of an asset (if it's a sheet). If you are trying to promote gantt, card, calendar, or the new Board or Timeline views of an asset, it would be great if the user configuring the shortcut widget had the option to…
-
Making a Gantt View with only working days (Mon to Fri, exclude public holiday)
Is there a way to remove weekend and public holidays from Gantt chart? I'm planning a project with long durations per milestone, I would like to see only working days in the columns; alternately, can I have the duration formula only calculate # of working days?
-
Count number of tasks by day to know how many workers are needed
Hi Everyone, Brand new to smartsheet and I have very little understanding of it's capabilities. I've built an extensive gantt chart with tasks going out over a year. When I manually count the tasks, I can see that I need anywhere between 2 and 5 workers on a given day based on the number of active tasks. As I continue to…
-
HELP - Creating dependencies but using start-date instead of lag
I am building a plan with my stakeholders, we have a number of sprint-based tasks that have dependencies. It is very painful to constantly use the 'lag' function for all of these. How can I:1. Link activities using dependencies so they can be visualised in the plan. 2. Allow me to put in a start-date for the successor…
-
Unparsable IF( & Gantt
I'm trying to make my Gantt display carry my current projects out with a hidden "completion date" row and IF= code, but it won't work. If my unhidden completion date cell is blank, I want it to autofill todays date so my gantt will show current projects, but if my viewable completion cell has a date in it, I want it to…