Hi, I've tried looking up other questions to answer this and got as far as this formula [=IF(Deadline@row <= TODAY(+14), "Green", IF(Deadline@row <= TODAY(+7), "Yellow", IF(Deadline@row >= TODAY(0), "…
Here is my formula to track Corrective Action status based on total attendance points. =IF([Total attendance points]@row > 7.9, "TERM", IF([Total attendance points]@row > 5.9, "FINAL", IF([Total atten…
I need to create a parent row that shows a rollup view of budget for all of the children, but I don't want to add another row/line item to my Master Sheet with the parent row because it will get too c…
Hello, I'm having trouble creating a formula that will sum if multiple criteria in a single column are met. I want to sum LOE column when the capability = one of 4 values. I'm using the SUMIFS and OR …
Data that I'm importing via Data Shuttle includes a date field (named Date Issued) with this format: 2022-01-22T10:30:55.999999889172613350 I added another date field (named Issued Date) where I added…
I can't get my COUNTIFS equation to work, it always just returns 0, can anybody help? =COUNTIFS([Column A]@row, "None", [Column B]@row, "None", [Column C]@row, "None", [Column D]@row, "None", [Column …
I have an issue with my sheet where we rank the total number of projects closed from 1-5. Rank is in the first column, second column is a formula: =MAX(COLLECT([Total Project Closed]:[Total Project Cl…
I need a Date (the Actual End Date) in the Description Column Row 35.when the Task cell equals the task of current row. and if no date in that cell to be blank Current formula is =IFERROR(DATEONLY(IND…
I have been playing around with the IF formula and thought I finally got the hang of it. However my "overdue" statement is not working and just set's it to "In Progress" when percent complete is not 1…
So i have one field where i need my team to input purchase order number (Correct PO number (unit team to update)). Once they put it there, i want to put a formula in next column that acts as a validat…
