Hi, I need help in creating a multiple if statement with text & a wildcard. I have an existing formula that works, here,
=IFERROR(IFS(G34<=TODAY()-10,IFS(J34=”Sent”,”Overdue”, J34=”Sent to Bean”,”Overdue”)),””)
what I need to do is only have this run if the prefix of the reference on column A starts with OLP (the cell contains a reference number i.e. OLP1234
I thought I could just add another if statement with a wildcard “OLP*” at teh beginning but it just wont work, can you help?