-
Would Report have the ability to filter columns as per new features announced in ENGAGE 2020?
Hi All, I created a report using report builder that consolidates data from different project plans at the lower level with a set criteria. I am trying to see if there is a way to filter KPI within the report. As I am aware that Smartsheet will be rolling new features in the report announced in ENGAGE 2020, I wanted to…
-
COUNTIFS PARENT cross reference
In my summary sheet, I need to cross reference the PARENT rows in my data sheet (status) to count the number of open non-conformities (with less than 100% complete). Basically, the counting in summary sheet needs to take into consideration two conditions in the status sheet: Be a PARENT row, and % complete <1 I have tried…
-
Actual % Complete vs. On Schedule % Complete
Hope everyone is doing well? I'm looking for a formula or suggestions to accomplish the following: IF “On schedule % Complete is > Actual % Complete then the task is “Late”, “Red Ball”. IF “On schedule % Complete is < Actual % Complete then the task is “On track”, “Green Ball”. IF “On schedule % Complete is = 0% (Actual %…
-
Automate RYG For Project Tasks
Hi All i am very new to SmartSheet. I am working on the project template which can help to highlight some tasks that have been overdue with RYG. Need your kindly help on the formula... 1. If task status is complete: Green 2. If the task status is Not Started: 1. Scheduled End Date is behind today: Grey. 2. Scheduled End…
-
Our drop down list is dynamic - how can I pull the choices from a list somewhere?
I would like the drop down list to be specific to a group of people (set up in group management). Rather than manually putting in the people that you can choose from, as this group continuously changes, how can I make this dynamic?
-
How do I pull a specified group of people through to a grid?
Group management means we can set up people into groups, but how can I then pull through these people into a grid? I want to analyse workload for a specific group of people. Alternatively, how do I pull through ALL contacts into a grid and make sure when a new contact is added it is automatically pulled into a grid?
-
How do I pull resource capacity into a grid?
I need to be able to manipulate the capacity data further. How do I pull this through into a grid to analyse?
-
Content Workflows
How can I set up an approval workflow for items like blogs with multiple editors, which can move a document or task from one editor to the next in line? Also, is there a way to set up tasks when those editors need to approve items, with deadlines? Say when Editor #1 is done and indicates an "approval", can I set a task…
-
Changing Status Based on Another Sheet
Is there a way to link a cell from sheet A to respond to a change in Sheet B? For example, if I change a cell in sheet B to "under review by editor" could I change a corresponding cell in sheet A to "In Edits"
-
My Smartsheet Wishlist
I wish, I wish upon a sheet that these will someday be a reality...if some of these are already posted, I apologize... Product team - most, if not all, of these were sent to Scott Willeke verbally or via e-mail so he could lend more context. These items are some of the things that would make Smartsheet even smoother.…