-
RAID Risk Matrix
Hi, I have the below matrix, is there any easy way to get the formula to do the various risk levels (low, medium, high and extreme)? I have attempted to try with AI the formula but for some reason starting with the last scenario of Extreme it stopped generating a formula.
-
INDEX & MATCH function showing "#INCORRECT ARGUMENT SET"
When trying to run this it shows "#INCORRECT ARGUMENT SET" error, not sure where i went wrong. =IFERROR(INDEX({East - Service Status}, MATCH([Ticket No]@row, {East - Service Range 1}, 0)), IFERROR(INDEX({South - Service Status}, MATCH([Ticket No]@row, {South - Service Range 1}, 0)), IFERROR(INDEX({Tamil Nadu - Status},…
-
Did they change how contact list and formulas interact?
I have a sheet that is mapping the supervisor email from a different sheet using vlookup (I want to keep this formula active in case there are supervisor changes). The format for the supervisor email is contact list. I'm using the supervisor email mapped in a countifs formula that was working last week. Now I'm getting #NO…
-
Will the AI Tool be made available in some form for Business plan users at some point?
Will the AI Tool be made available in some form for Business plan users at some point? This would really benefit me creating formulas, I've always struggled with them! 😣 Please consider!
-
How can I get this formula to return a value when two criteria are met?
Initially, I used the formula below to return the Payment Term value from my Contract & Exhibit Tracker where the vendor #s match between my source sheet and output sheet. And it worked. =IF(ISBLANK([Vendor #]@row), "No Match Found", IFERROR(INDEX({Contract & Exhibit Tracker - Payment Terms}, MATCH([Vendor #]@row,…
-
COUNTIF reference not working
I have a time entry on one sheet where times are entered in the HH:MM (24 hr) format and another column that pulls the hour of that day. [Time Received (FORM)] - time in HH:MM format [Received Hour of Day] - pulls the hour of the day with the following formula: =IFERROR(LEFT([Time Received (FORM)]@row, FIND(":", [Time…
-
Nested(?) If statements
Not sure if nested is the right term. I want the formula to show - If any of these columns (IT, SUS, HSE etc) have "Not Achieved" in them then look for the largest/ latest date from the columns IT comp. SUS Comp. HSE Comp. and display that date. Otherwise "Badges complete". The result column is a date column so not sure if…
-
Formula Functions causing cell references limit error?
Hello, I'm trying to determine which FUNCTIONS I'm using in column formulas of a program schedule sheet that may be causing too many cell references so that I'm going over the limit of 25 million references (when I have around 3000-4000 rows). Most of my formulas just have @row formulas, but I don't know what some of these…
-
Install Comparison Actual to Projected
Good Morning Community. I wanted to ask a question as it pertains to a comparison. We have been asked to show a chart that displays installed, not installed and projected installed. The premise is that in our project we have specific dates that are targeted for installation but with everything in project management that…
-
Date Range and status formula
Hello, I have a metric sheet where I am trying to build a formula that references a date range column and status column of another sheet, but I keep getting "unparseable" or "incorrect argument". I have tried the following formulas: =COUNTIFS({Event Date},>=(2024, August, 1),{Event Date}, <(2025, August, 1),{Event…
