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.

Screen Shot 2020-12-15 at 16.32.38.png


Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!