Reason | Wave | Short | Hem | Use |
Blocking, Short, Sticking Hem | Bloc | Burn | Stic | 4 |
Hem | Inc | Burn | 0 | |
Short, Hem | Weak | Inc | 3 |
<tbody>
</tbody>
I want to have the "Reason" Column (approximately a few hundred rows a day) automatically populate based on the values of certain cells. I added a table above for reference of what I am trying to accomplish. If there are values in the Wave, Short, Hem, or Use Columns, those will all need to be shown in the Reason Column, separated with a comma and space as demonstrated above.
A few tricky parts:
- For "Wave", I want the "Reason Column" to display "Wave" only if "Bloc" is in the "Wave Column"
- For "Short", anything that is not blank will result in "Short" being displayed in the Reason Column.
- For "Hem", if the value equals "Stic", I want the reason to show "Sticking Hem". If it has any other value that is not blank, I want the reason to only show
- For "Use", if the value is any number greater than 2, I want Reason to be shown as "Short", but only if it does not already state short from previous entries
I greatly appreciate the guidance!