How to update a cell with "if / and" condition

Hi, I am trying to figure out the automation or formula to auto update a cell with "if / and" conditions are met.

Please help me achieve this.

If Column 'Headset' values is = Column 'Asset ID' value and Status Column of same row of Column 'Headset' is 'Shipped', update Availably Column, same row of Column 'Asset ID' to not available.

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!