-
At Risk Sheet Summary
I am hoping to create a sheet summary formula that will flag a something as "at risk" if it is past five days since the date in row 1 of the "Oldest App on Hand" column. I need it to only pull from that one cell, and be indexed to row one as more rows are added over time. Thank you in advance for any help!
-
Auto Calcuate Due Date Formula
I am trying to calculate a due date based upon a 5, 15, 30 day criteria. The problem I am running into is that the way I have the 1st row of each area setup (it is broken down by equipment, then sub categorized into dates). I have a formula setup to auto calculate the # of days criteria based upon "low, medium, high"…
-
Formula for Sum of distinct row and value
Hello, I'm attempting to write a formula in the "total annual value of items per patient ID" that sums all the item value per distinct patient ID each time I enter a row. Anyone can help?
-
Year formula
I have a formula that is working that is counting the # of quotes that have been won by month which was working for 2023 now that its 2024 I want to show 2023 separate and start new for January 2024. The formula that Im used for 2023 is below. I believe that I just need to reflect the year into my countif formula and tried…
-
What formula to write - Vlookup or Index/Collect Formula???
Hello, I am creating a New Hire and CFO Buddy Tracker to assist me with paring new hires to mentors within the company. I have two sheets set up one that has the name of all the mentors currently available and another with the list of New Hires. The idea is that on the Mentor list I want it populate with the name of the…
-
Want a formula to autopopulate the task names of other rows
So, I have a project. We have milestones listed at the top, which are not tied to any waterfall style deliverables. They are just each their own milestone, with 0 duration, and manually entered dates. I don't want to create a complex GANTT chart just to get the dependencies between milestones to show. So I am trying to…
-
Is there a template that will work for the project that I am working on? We will also need it to run
Is there a template that will work for the project I am working on? We will also need it to run in a dashboard. I have 1200 clients, and each client will need a POS upgrade by Jan 1, 2025. I need to check a box on each account that has been completed and show the progress in a graph. chart. It might not have to be a check…
-
Im trying to assign a formula only to parent cells, to get % completed
I have a column called "Done" and i want the child cells to have checkboxes and the parents to have the % of the project done( some rows dont have child cells and are stand alone). I have a formula that works: =IF(COUNT(CHILDREN([Primary Column]@row)) >= 1, COUNTIF(CHILDREN(), true) / COUNT(CHILDREN()) * 100 + "%") but I…
-
Sum of submissions last week
Hi there, I want to create a formula that will return the sum of submissions in a column from the previous week (I want a static snapshot from the previous week, as opposed to a rolling 7-days). I have a formula that is working for returning the sum of submissions from the previous month, and I tried modifying it to pull…
-
RYG based on cell value
Hello, I'm trying to set the RYG ball based on the value of a cell and I can't seem to get it right. If the value is: Greater than 0 = Green Between 0 - 0.5 = Yellow Less than 0 = Red =IF(Remaining@row > 0, "Green", IF((Remaining@row >0, AND(IF(Remaining@row<0.50,))), "Yellow", IF(Remaining@row<0), "Red")))