Formulas
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
Answers
-
Without knowing the names of the columns I had to just enter [Ship Set X] as the column names.
- =IF(AND([Ship Set 1]@row="ready for shipping", [Ship Set 2]@row="ready for shipping"),"yes", "no")
If there are a huge number of Ship Sets the formula above could get rather long. Additionally, if the numbers of Ship Sets are inconsistent, you would need to account for those being blank. You could do that by adding something like:
- =IF(AND(OR([Ship Set 1]@row="ready for shipping", [Ship Set 1]@row=""), OR([Ship Set 2]@row="ready for shipping", [Ship Set 2]@row="")),"yes", "no")
Let me know if you need help! As an FYI, the link you provided will only open for those who have access to the sheet.
Best,
Zach Hall
Training Delivery Manager / Charter Communications
-
Hi Zack, Thanks for your help! I'm looking for another formula in this case. Do you want access to the smartsheet? Please request acces.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!