-
IF/Match
Good afternoon, I'm having a problem with the below formula. I'm trying to do a formula that will check Invoice numbers on two sheets. If they match it will say yes, and if there is no match it will say no. However I'm getting Invalid Data type when there is a match, and No match if they don't match. =IF(MATCH(Invoice65,…
-
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"