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.
Help Article Resources
Check out the Formula Handbook template!