Hi, I want to create a formula in a cell that returns 'yes' or 'no'. I would like to receive either 'yes' or 'no' in the cell based on whether the 'ship set' is complete. A Sales Order (SO) can consist of multiple ship sets. An SO can only be shipped if the corresponding ship sets are ready and have a status of 'ready for shipping.'How would I do that? My efforts have failed. Link to example: https://app.smartsheet.com/sheets/J6m4hWhMJJRVGx3r22Pc62HfwX3pcQ52Mg5XJWh1
Help Article Resources
Check out the Formula Handbook template!