-
RYG Formula for Parent and Children Rows
Hello, I am trying to create a formula where the parent health turns Red if there is more than 3 red children health's, Yellow if there are more than 3 yellows, Blue if everything below it is Blue and the rest of the time green. Is this possible? I was using this formula for a while, but realized major gaps and it wasn't…
-
COUNTIF Question
Is there a formula that allows me to count the number of cells within a range that contain a certain string of text, where the cells in the range also contain other text?
-
RAG indicator options
Hi there community I have a portfolio of several hundred projects being monitored and reported via dashboards and reports in Smartsheet. We are currently using RAG indicators against schedule as follows: Red - Incomplete at reporting date or due date passed Amber - at risk Green - schedule within tolerances (+/- 10%…
-
calculating status based on status of multiple columns
Hi, I am trying to calculate the status of a main column ("status") based on the status of multiple columns (OP2-OP8). The idea is to automatically change the status (on the left) from "Open" to "Complete" based on the individual status of the columns on the right (Open/Closed). Background: we try to monitor the issue…
-
Reporting like pivot or sumif. How to roll up values by name or category?
Is there a way to combine cell entries and give the total assigned to that category? Ex. Project Lead Cost savings John $100 Mary $500 Bob $400 John $200 Mary $75 Bob $60 REPORT = John Total = $300 Mary Total = $575 Bob Total = $460
-
How to use multiple NOT in cross reference formula
Hi, I am implementing a formula which is taking cross reference from another sheet, let the column I am using be Column1, Let it have 10 different values. I want to get the count from this column where the value is not String1 and not String 2. I didn't find any usage with multiple nots, can somebody help?
-
Can anyone recommend the best formula to calculate overdue tasks?
Currently using- =COUNTIFS(AND({SS Project Plan Completion Date Range}, NOT([{SS Project Plan Status Range} = "Complete")]) < TODAY()) I want to exclude completed task from the count. Currently returning UNPARSEABLE error
-
I need a checkbox formula where criteria is one of many dropdowns selected for a given cell
I'm trying to write a formula that would check a checkbox if a dropdown selection is chosen for a specific cell, where other dropdown selections are also chosen. E.g. Dropdown selections a,b,c,d are all selected as all apply, and I want a checkbox in a separate column to populate if selection 'a' is amongst those chosen.…
-
#UNPARSEABLE: Trying to count two selections as a total based on assignment and a label of "engaged"
-
Date autofill to most recent date entered
If you have a parent row with a blank date column and "children" rows with dates listed in each separate row, is there a way to have the parent row equal the most recent "child" row date?