mercredi 10 octobre 2018

Google Sheets: Multiple "if" and "find" within an Array formula

background info - not important

I realise I need improvement on understanding logic and understanding documentation when playing around with Android apps. So, I thought I'll switch to Google Sheets in the hope of some basic practice in a context I might find easier to understand.

question

I've set up a Google Sheet: https://docs.google.com/spreadsheets/d/1T7q_CGMFObxS_0DGikUdSdLTf97XmEPXY0S7yItuA5Y/edit?usp=sharing

I would like Column B to: - display "Folder1" if "Black" is found in the adjacent Column A cell. - display "Folder2" if "Blue" is found in the adjacent Column A cell. - display "Folder3" if "Green" is found in the adjacent Column A cell.

and to then be able to add more conditions.

My formula for Column B is currently: =ARRAYFORMULA(IFS(find("Black", A2:A,1)>0,"Folder1",find("Blue", A2:A,1)>0,"Folder2",find("Green", A2:A,1)>0,"Folder3"))

Which is only meeting the first condition "Folder1" if "Black" is found and not continuing with the rest of the ifs.

I think I have nested it correctly though because all of the IFS() are at the same level with their corresponding find() within. And, I have two closing brackets which close the IFS and the ARRAYFORMULA.

Am I just simply not using the right kind of functions for what I'd like to do?

Thank you for your suggestions on how I can solve this!

Aucun commentaire:

Enregistrer un commentaire