Update a cell from the list with condition
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.
Help Article Resources
Check out the Formula Handbook template!