Simple IF OR Formula



I would like for the 'Invoice to Cust' Column to update to "No" WHEN 'Cost Recovery' is either "Blank to Invoice" OR "Operation to Invoice".

^Apart from this, if it is doable; I would like to add to this formula of WHEN 'Status' is "To be Invoiced" will update 'Invoice to Cust' to "PENDING"

However, if the last ask is too much, I would love the assistance with the initial ask :)


Thank you!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!