-
Overall RAG Automation: Risk Register
Smartsheet Community: Has Anyone Automated RAG for The Overall Risk Register? For Example, The Risk Register has 6 Risk, 3 are Red, 2 Yellow, 1 Green Resulting in an Overall RAG Rating Yellow. Thanks
-
Two Form Solution - Multiple Lines in a Smartsheet & Special Conditioning
I was grateful to receive an email from Andree in relation to a two form solution for submitting one form with multiple lines of data; however, I have two additional questions. In Andree's file there is a toggle on the main form to generate the results from the two forms. How do I create this toggle? Additionally, the data…
-
Countif Formula not reporting Accurate number
Hello, I'm trying to report a metric on a dashboard and am using the following formula: =COUNTIF({Master Project Tracking Range 1}, ISBLANK(@cell) and the total is 29, however when I filter the grid the data is pulled from there are only 19 blank cells. I've also tried =COUNTIF({Master Project Tracking Range 1}, "") and…
-
Parent/Child row formula
What would be the formula to use for when you want to update the parent row with child row data? For example, if a subtask under the parent row is marked as 'In Progress,' I'd like for the parent row to be reflected as 'In Progress.' Thank you.
-
Need to Upgrade my Task Health Formula!
Hi! I have a very basic formula in place to calculate task health (red or green) I am currently using: =IF(AND(Status@row = <>"Complete", [Due Date]@row <= TODAY()), "Red", "Green") I have two questions here. 1) I need this formula to also include "done" with "complete" IE... If the status is not "complete" OR "done" and…
-
Invalid Operation Error
Hello, I am trying to create metrics to review milestone phases for 2023 by week. I had my formula counting if the milestone phase is a certain value, if the date of that milestone phase was in a certain week of the year, and that the date value is not blank: That works great. However, because I did not define the year to…
-
Parent row to give a percentage when Child rows below are populated
Hello All Can anyone help me with a formula for my parent row below. I need to work out what percentage of days in a week I have booked out for our staff on projects. Currently I do this manually. As the only formula I have found have been for Tick boxes or completed tasks. The jobs are selected from a drop down list and…
-
Change risk color per multiple variables
Hello. Need some help with a multi variable formula. I have a RISK column. The column type is Symbols (Red, Yellow, Green). I have an END date column. I have a STATUS column (Not Started, In Progress, Complete) I'd like create a formula that by default the RISK is Green (green circle). If it is 2 days past END date it goes…
-
Counting range of cells within row
I'm trying to count the amount of times a cell within a row has a specific word: =COUNTIF([Labelling)@row,[Training]@row), "Fail") If Fail shows in any cell I want the function to result a readout of 1. If two cells have Fail, then the result would be 2, etc. Instead of my expected result, I get #UNPARSEABLE in the cell.…
-
How do you summarize symbol statuses?
I have my team provide project status updates on their goals via a "Request an Update" automation; we use the bar symbol (empty, 1/4, half, 3/4, full). Upon an update being made, it will change the status accordingly in the respective row. I have objectives that the goals ladder up to, and I'm trying to figure out a way to…
