Hello and thanks in advance for your help! I would like to automatically calculate the total # of "working days" left (as of today) by referencing the Due Date. I did find a formula for total number of all days left "=[Due Date]23 - TODAY()" but I haven't been able to find one that just calculates working days. Here…
I have a sheet for division entry. When it is approved by the director a workflow copies the entire row to a master sheet, where the commissioner approves. All approvals are a drop down symbol. When the commissioner approves, there is an index/match formula on the division sheet, indicating if commissioner approves or…
Hi - My project has 3 phases in it and I would like to be able to show not only the % Complete of each phase but for the project overall. I have each phase working by enabling the dependencies and it is already calculating for those but I cannot get a formula to work to calculate the over all % Complete for Row 1. Does…
What would be the formula that counts the number of dates that fall between a start and finish date if another column is not blank? Current formula I have is: =COUNTIFS({Dates}, >=[Start Date]@row, {Dates}, <=[End Date]@row) This is returning the total number of dates correctly. But would like it to return the number of…
Hello, I'm looking to set up a separate tracking sheet that captures ongoing counts based on our project intake form. I'm hoping to capture: # of requests created by Department (uses a dropdown on the main intake sheet) # of requests per Program (uses a dropdown on the main intake sheet) # of requests by Type (uses a…
Dear All, I am getting below error message. "Some cross-sheet formula can’t be updated, because this sheet has more cell referenced from other sheets than the maximum allowed (100000)" How can I fixed the above issue since I am maintaining history table and all completed records I am taking from historical table using…
Hello! I'm trying to write a formula that tells me how many rows meet the criteria in multiple columns. It works with criteria in two columns, but when I try to incorporate a third, I get an incorrect argument set, or an invalid operation. I can't figure out what I'm missing in the formula. Here's the formula that works:…
I am looking to change the formula below so that when I add columns it doesnt upset connected data. Was looking to change to index match but going round in circles. I can send further screen shots if necessary. Thanks for looking ❤ This is the formula currently in the sheet. =IFERROR(IF(ISBLANK(VLOOKUP(Country@row + " TT",…
Hi. I'm having trouble adding the second half of a formula. I am trying to build a rollup task summary. So I need a COUNTIF a task is due within 3 days, and the completed column is blank. I think that will get me to display only the task that is approaching their due date.
