Update a cell from the list with condition

Hello Experts,

How to auto update a cell from the list when conditions are met?

e.g. (screenshot) If the status is 'In Progress' - Look for the first available gear in the list and update a cell of a row (In Progress) with the first available gear ID.

Please Help!!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!