-
Can I copy rows based on a formula updating?
Hi All - I'm working on new process, and have everything working except one small (seemingly) problem. I have two sheets that talk to each other, and they work fine. In Sheet 1, I have a status field (drop down), and in Sheet 2 there is corresponding Status field. When Sheet 1's Status field gets changed, Sheet 2's Status…
-
Automate data into a cell from another sheet if criteria is met, then remove that data from source
Hello, I have a predetermined list of voucher numbers for exams. When a student meets certain criteria I want a voucher number from the source sheet to generate on the student's row automatically. After that voucher number has been used, it will need to be deleted from the source sheet. The voucher numbers come from the…
-
Calculate the right average for the columns
I need the average collect to calculate the right total % complete for the columns Each column that has a date is = 100% If there is no date is = 0% but the formula still counts the 0% to give the total % average complete on "Quote % Complete" column. If there is "N/A" either in "1st Circuit Quote Status or 2nd Circuit…
-
Does INDEX(MATCH) work on a column with a formula?
I am attempting to use the INDEX(MATCH) formula with the range being a column that is calculated with a formula. I keep getting a #NOMATCH message - can MATCH only work on a column that has actual values (i.e., not values calculated from a formula)? I am trying to use this formula: =INDEX({Billing Code}, MATCH([Identifier…
-
#REF error on furmula
Hi, I have some formulas for a dashboard that have been running for quite some time and now all of the sudden I receive this error "#REF" on them. I have double checked to see if something has changed but no, everything is still the same. I also checked some of the answers for other people with the same problem but there…
-
Need formula help.
I have the following formula: =IFERROR(IF([Date Complete]@row = [Due Date]@row, 0, IF([Date Complete]@row > [Due Date]@row, NETWORKDAYS([Due Date]@row, [Date Complete]@row) - 1, IF([Date Complete]@row < [Due Date]@row, NETWORKDAYS([Due Date]@row, [Date Complete]@row) + 1, ""))), "") How do I add a contingency for if the…
-
Subtracting 1 month from TODAY, previous year error
=DATE(YEAR(day13), MONTH(day13) - 1, DAY(day13)) I am using the above formula to subtract one month from today's date for a rolling 12 month report. However, the formula errors above 15/01/22 (I expected it to revert to 15/12/21) is there a way I can build the formula so it does not error and continues into the previous…
-
Trying to check a box using OR
I want a box to be checked IF Sales Status is "Verbal Agreement" or "Deployment Prep Call - Scheduling" or "Deployment Prep Call - Scheduled" =IF([Sales Status]@row = OR("Verbal Agreement", "Deployment Prep Call - Scheduling", "Deployment Prep Call - Scheduled", 1)) I'm getting the error INCORRECT ARGUMENT SET. Thanks for…
-
Find the average of hours, minutes, seconds
Hi there, I am having difficulties finding the average of hours, minutes and seconds. I have 12 months of data for timings, and the format is in hours, minutes, seconds how it is in excel - 00:00:00. I have to find the average for each month, for an entire years worth of data, and it gives me an error when I look for the…
-
Latest Modified Date/Modified by Formula
Hello I need help on a formula tracking when a particular person has modified a sheet. I have 25 project plans that I am admin for. I need to find out when the last time the project manager updated their plan. I have the following formulas running against the Modified and Modified By column. However, I need to update the…
