I have a spreadsheet that I send out to coworkers regarding scrapping obsolete inventory. For example, what I would like to do is to set up the spreadsheet so that based on what they choose in a list, they may or may not be required to add something in the cell next to it. Example below.
<tbody>
</tbody>
So based on the answer "Do not Scrap," I would like for the reason column to have a requirement that they put something in that column.
Thanks in advance!
David
Part Number | Scrap/Do Not Scrap | Reason |
123456 | Scrap | **Do not need Reason** |
789123 | Do Not Scrap | **Need Reason** |
456789 | Do Not Scrap | **Need Reason** |
<tbody>
</tbody>
So based on the answer "Do not Scrap," I would like for the reason column to have a requirement that they put something in that column.
Thanks in advance!
David