-
Project Status Reports
Hi All, In our PMO function we are looking to create project status reports in Smartsheet that would be a 1 page for a PM to update RAG, finance outlook, comments etc. We would have 1 sheet per project, that we could then roll up into a report and query in Tableau for board reports. Has anyone got a good example of this…
-
RYG Automation using Drop Down lists
Hi I've watched a few videos on RYG automation based on due dates but is anyone able to help with the IF function using categories from a drop down list instead? I.e. Looking at Recruitment Status: If someone chooses 'On Hold' from the drop down, I want the RYG column to show Red. If someone chooses 'Interviews and…
-
Return entire row when value is matched in another sheet
I have a source sheet with hundreds of rows of entries. One of the columns is named Property. There are many different values under this column. I have a destination sheet for each one of these possible values (in this case, a property). What I would like is to have have any rows in the source sheet which match a specific…
-
Sharing Sheets to Multiple Workspaces
I was wondering if I could have a sheet be located in multiple workspaces simultaneously. For example If I wanted to have individual workspaces for each project I am working on, but also have separate workspaces that would allow me to see overviews for ALL projects, all pulling from the same sheets.
-
Back calculation of dates in Gantt View
Hi there, I'm building a schedule in Gantt View by back calculating from an end date. The issue I have (refer attached screenshot) is that I require the finish of the task at row 353 to be the earlier of the start of row 355 or 2 x weeks prior to the start of row 32. When I put in what I understand these predecessor…
-
Line Break as Delimiter in JOIN(CHILDREN()) Formula
1. I want to aggregate text information from child cells and use a line break as delimiter. How can I do this? 2. In Addition it would be nice to have "Primary Column" as prefix before the respective contents. Example Values for Primary Columns for two rows: Child 1, Child2 Value for relevant text cell of child 1: - lorem…
-
Feature Request: Adjust Lag Time in Calendar View
I imagine this has been mentioned already, but it would be great if I could adjust lag time for tasks in the calendar view. The calendar view is great for load balancing, but it's a pain to have to go back and forth between the calendar and gantt view to adjust the dates.
-
Report with only parent rows
I am new to Smartsheet and I'm trying to create a report from multiple sheets that have parent rows and child tasks. I'm looking for a report that puts together all the sheets but only shows the parent rows from each sheet along with the information on that row - percent complete, gantt information etc.
-
Problems with Cell Linking working on some cells but not others
I help develop Smartsheet sheets and reports, and link cells from project plan sheets to an overview portfolio sheet. Recently I've seen where some cells link properly, but some cells don't. I've tried removing the links and re-linking, but to no avail. Guidance is appreciated.
-
Creating Dashboards
I am new to creating dashboards in SS. I have gone through the SS online tutorials and not finding the details I need. I need to create reports using formulas and what I have tried I have not been successful. Does anyone have suggestions on other materials to review?