Hello, I am trying to have a formula in my primary column to have a date-number of tickets created on this day. so I would have 11/02/21-1 in row 1, 11/02/21-2 in row 2 and so on. However, when A cell…
I'm struggling to complete a formula to do the following: If Status is Complete, mark the health green. If Status is Not Started or In Progress and End Date is 10 days or greater, mark health green If…
Hi all - I am trying to determine if a task is ready to start based on all of the predecessors being 100% complete. I have numerous tasks with more than 1 predecessor and I've parsed out all the prede…
Can someone please help me with a formula? I want to automate the yellow ball two days before the due date and the red ball the day after the due date when the "Done" column is not checked. Thank you …
This is my current formula. I have added a drop down option in my status column "NA". I have also changed my health column to include a gray light option. Can someone help me add this to my current fo…
Hi Formula Gurus, This should be straight forward but I keep getting 0 or 1. I'm looking for a count of projects do not have a Project Category of "test" and they have Year Started is 2023 (or yr 2024…
I want to use index collect to get who worked on a job from a different sheet =INDEX(COLLECT([ASSIGNED ENGINEER]@row, [JOB NAME]@row, <>"", [JOB NAME]@row, <>""), 1) This works on the same sheet but w…
I have a calculation sheet with the formula =COUNTIFS({Sent to AIR-360}, >[FY Start Date]@row, {SR Type}, ="NTSB", {Sent to AIR-360}, >{AIR-360 Due Date}). The formula is to count dates greater than F…
I would like to follow a task and see the difference between when it was planned and actually done. To be more precise. Column "Agreed Date" is used on what date the two parties agreed to finish the t…
I have a set of data for monthly KPI's. The user may enter the same KPI with a different dollar value multiple times. Once I identify the last entry for each combo of calendar month, fiscal year and m…
