ISBLANK Function
Relevant answer
={"Our Notes"; ARRAYFORMULA(IFERROR(vlookup(B2:B, Notes!A2:Z500, 2, false), ""))}
Relevant answer
I didn't know about this CHAR(10) thing so I'm commenting so I can find this thread later.
Relevant answer
You can modify the formula to only record the timestamp when the value in column M first becomes "Active" using the IF and ISBLANK functions. Here's an example formula:
=IF(AND(M2="Active",ISBLANK(N2)),NOW(),IF(ISBLANK(N2),"",N2))
This formula checks if M2 is "Active" and if N2 is blank. If both conditions are true, it records the current date and time using the NOW function. If N2 is not blank, it displays the existing timestamp in N2.
If M2 is not "Active", or if M2 is "Active" but N2 already contains a timestamp, the formula returns an empty string, as per your original formula.
Once the timestamp is recorded, it will not change even if the query refreshes and updates the value in column M again in the future.
You can drag the formula down to apply it to other rows in the column.
Relevant answer
You can use a split formula here to get the date by itself. Try this formula below.
=arrayformula(iferror(split(H3:H,”T”,””))
Relevant answer
Make a smaple table with data and desired data than share screenshot
Relevant answer
=INDEX(SORT(FILTER(J5:J,NOT(ISBLANK(J5:J))),RANDARRAY(COUNTA(FILTER(J5:J,NOT(ISBLANK(J5:J))))),1),)
Relevant answer
suggest using conditional formatting in column D to remind people there is something missing if the cell beside the first Assy# in B is empty
- select D5:D30,
- conditional formatting, formula =and(d5="",b5<>b4)
- choose color to run
Relevant answer
In CELL G2: . =IF(ISNUMBER(F2),F2-D2,"NA") . In CELL H2: . =IF(ISNUMBER(F2),0,TODAY()-D2)
Relevant answer
=IF(ISBLANK(I2),"",IF(I2>TODAY(),CONCATENATE("Due in ", DAYS(I2,TODAY()), IF(DAYS(I2,TODAY()) =1," day"," days")), IF(TODAY()-I2=0, "Due Today", "Overdue")))
Use this and paste it on cell "J2", then drag it down till "J8". It should work.
Relevant answer
You could put in an if statement. =if(isblank(J2),””,
Relevant answer
And(a1<>"",h1<>"") Both must be not blank Or(a1<>"",h1<>"") One of them not blank
Relevant answer
Ifs() function comes in pairs, logical argument and the value if it is true. Looking at the 3rd pair in your formula for example, the logical argument is not comparing to anything but just texts. Looks like you followed the syntax of an IF() function and applied it on an IFS() function. Might reconsider your formula to have a nested IF() function in that case.
Relevant answer
=IF(OR(AND(ISBLANK(E2),E3>E5),AND(NOT(ISBLANK(E2)),E3>E4)),"Not required","Required")
Relevant answer
- Where do you want the Result and in what Format ?
- Even if say NEVER will happen, still should include something in Formula/Function to cover that...
Relevant answer
To understand your query as well as the mentioned formula, please include row/column headers in your screenshot, or better yet share a sample sheet.
Hot network questions
