[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Reason[/TD]
[TD]Wave[/TD]
[TD]Short[/TD]
[TD]Hem[/TD]
[TD]Use[/TD]
[/TR]
[TR]
[TD]Blocking, Short, Sticking Hem[/TD]
[TD]Bloc[/TD]
[TD]Burn[/TD]
[TD]Stic[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]Hem[/TD]
[TD]Inc[/TD]
[TD][/TD]
[TD]Burn[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]Short, Hem[/TD]
[TD][/TD]
[TD]Weak[/TD]
[TD]Inc[/TD]
[TD]3[/TD]
[/TR]
</tbody>[/TABLE]
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:
I greatly appreciate the guidance!
<tbody>[TR]
[TD]Reason[/TD]
[TD]Wave[/TD]
[TD]Short[/TD]
[TD]Hem[/TD]
[TD]Use[/TD]
[/TR]
[TR]
[TD]Blocking, Short, Sticking Hem[/TD]
[TD]Bloc[/TD]
[TD]Burn[/TD]
[TD]Stic[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]Hem[/TD]
[TD]Inc[/TD]
[TD][/TD]
[TD]Burn[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]Short, Hem[/TD]
[TD][/TD]
[TD]Weak[/TD]
[TD]Inc[/TD]
[TD]3[/TD]
[/TR]
</tbody>[/TABLE]
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!