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