-
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?
-
Update Request - Shows Sending, but Not Received
Hey all - Been using all the great functionality of SS for quite some time now. I have an Automated rule setup so that when a person Submits a certain thing, an Update Request is Automatically triggered. I've had several of our AEs reach out saying they're no longer receiving them, but when I go into SS, I can see that the…
-
Formula to check box when 2 criteria are met: older than 180 days and another box is checked
I can't get get my formula to work. I am trying to get a box in one column to check when the date in another column exceeds or is equal to 6 months (180 days) and when another box in a third column is checked. This is what I have, but I think it's the checkbox condition that's throwing things off: =IF(AND([Start Date]@row…