Help Required


I think I might need help with using MATCH but not 100% sure if its the right way to go

I have a sheet with a column named Job Number and another column named Status

I am looking to search for any matches in the job number column and if there is a match AND the status column in this matched row is closed I want to set my initial column status also to be closed.

Hope that makes sense !!

Any help appreciated


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!