-
Dropdown list - Update from the dev team ?
Hi everyone, TL;DR : When will we be able to have dynamic dropdown for a column / field in a form? Is there a workaround? I can't think of a single project where this CAN'T be used... I'm using Smartsheet more and more to provide simple solutions to my clients regarding their work (finance, managing team, project...). I…
-
Move Rows to Another Sheet...that contain formulas
Hello! Has anybody had experience trying to automatically move a row containing formulas to a new sheet? I am trying to pre-populate cells with formulas that would apply on a different sheet so that they will be ready to go once moved over during a workflow.
-
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…