I currently have a formula I put together and all has been well, except now there have been a few slight changes and I need help
For simplicity purposes, I am not going to post the entire formula as it is long, I only have one part I am concerned about
My formula is similar to If(item = "Approved; emptystring; Pending)
This formula will say that if the item equals the word “Approved” it will return nothing, but if it does not equal “Approved” it will return the word “Pending”
How do I edit this formula so if item CONTAINS the word “Approved” it will return nothing. Bonus points if this doesn’t have to be case sensitive either
Thanks so much for anyone who can help