Conditional Additions

[KansasLane]

I'm new here.
I am wondering if anyone knows how to add and option in a column to add another column.
For example, I want to record what chemicals I am applying, and since sometimes there may be up to 7 chemicals at a time, I want the option to record each one, or if there are fewer (obviously no less than one), I want the option to have just one column. I want to be able to enter information in one column, as well as have the option to add another column in case I am applying another product. This will have to be more complicated than formatting because I intend to lock the features and share it with my employees so that they can document what all they do as they do it.
Hopefully I did not explain this in a confusing way. Any help is appreciated!

 

[oldbrewer]

in excel you have hundreds of columns of course. If A1 = copper sulphate that is all you see if B1 = nitric acid you see both

you could see if you wanted copper sulphate - deliberately empty - deliberately empty - deliberately empty - deliberately empty - deliberately empty

 

[sandy666]

is that what you want?

[Table="width:, class:head"]
[tr=bgcolor:#FFFFFF][td=bgcolor:#5B9BD5]col1[/td][td=bgcolor:#5B9BD5]col2[/td][td=bgcolor:#5B9BD5]col3[/td][td=bgcolor:#5B9BD5]col4[/td][td][/td][td=bgcolor:#70AD47]Column1[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]aa[/td][td=bgcolor:#DDEBF7][/td][td=bgcolor:#DDEBF7]abc[/td][td=bgcolor:#DDEBF7]12a[/td][td][/td][td=bgcolor:#E2EFDA]aa[/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][td]

123​

[/td][td][/td][td]23b[/td][td][/td][td]bb[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]bb[/td][td=bgcolor:#DDEBF7]

234​

[/td][td=bgcolor:#DDEBF7][/td][td=bgcolor:#DDEBF7]aa[/td][td][/td][td=bgcolor:#E2EFDA]

123​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

123​

[/td][td]

567​

[/td][td]def[/td][td]34g[/td][td][/td][td]23b[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7][/td][td=bgcolor:#DDEBF7][/td][td=bgcolor:#DDEBF7]ghk[/td][td=bgcolor:#DDEBF7][/td][td][/td][td=bgcolor:#E2EFDA]

234​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]23b[/td][td][/td][td][/td][td][/td][td][/td][td]

567​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][td][/td][td][/td][td][/td][td][/td][td=bgcolor:#E2EFDA]abc[/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][td][/td][td][/td][td][/td][td][/td][td]def[/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][td][/td][td][/td][td][/td][td][/td][td=bgcolor:#E2EFDA]ghk[/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][td][/td][td][/td][td][/td][td][/td][td]12a[/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][td][/td][td][/td][td][/td][td][/td][td=bgcolor:#E2EFDA]34g[/td][/tr]
[/table]