Multiple ISBLANK

[EmmaTM]

Hi - I have the following in a spreadsheet:

In column J so far I have =IF(ISBLANK(B79),TEXTJOIN(,,"PROJECT CODE NOT LISTED: ",AB79),IF(ISBLANK(F79),TEXTJOIN(,,"RESOURCE CODE MISSING: ",AB79),""))

So if B or F is blank the detail is added into AB and this updates the notes.
I also need to add to this if AC= LATE TIMESHEET that needs to update J with that note.
If B&F are blank & AC is late timesheet I need the note to display all 3 options

Do I need to seperate AB and have a note for project and another column for resource code detail if B&F are blank?

Thank you

 

[EmmaTM]

Hey - I have this formula which is slightly extended to what we had above:
=TEXTJOIN(" / ",1,IF(E19="","PROJECT CODE NOT LISTED: "&R19,""),IF(C19="","MISSING RESOURCE CODE: "&S19,""),IF(Q19="","",Q19),IF(T19="","",T19),IF(U19="","",U19))
I want the last If statement IF(U19="","",U19) to be listed first but if I change it to this I am getting an error:
=IF(U19="","",U19),TEXTJOIN(" / ",1,IF(E19="","PROJECT CODE NOT LISTED: "&R19,""),IF(C19="","MISSING RESOURCE CODE: "&S19,""),IF(Q19="","",Q19),IF(T19="","",T19))

What do I need to do for it to work?

Thank you

 

[Peter_SSs]

I want the last If statement IF(U19="","",U19) to be listed first

Do you really mean listed first or do you mean after "PROJECT CODE NOT LISTED: " or after "MISSING RESOURCE CODE: "?

Could we have a few rows of sample data (some with column U = "" and some where col U is not "") and the expected results that shows what you actually want?

 

[EmmaTM]

Thank you Peter but I managed to work it out - thank you for replying, appreciate it.

 

[Peter_SSs]

I managed to work it out

Cheers. Thanks for letting us know.