This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
1. The number of Fields which differ by number suffix(1,2,3..) is NOT FIXED. So sometimes, there can be just two fields, Type and Type2. But sometimes it can be Type ~ Type 10 with 10 columns.
2. I need to build a dynamic formula which IF TYPE is blank, then use the Type2 OR WHATEVER COLUMN THAT HAS A VALUE.
At least the good thing is there will always BE JUST ONE column that has A VALUE. There will not be two or more columns with values. IF one column has a value, then REST columns will ALWAYS be empty. Just that the number of columns are not fixed but changeable.
1. In the workflow, I would have checked for Type 1 ... to Type 4 for example. If the source data actually has until Type 11. Then ALL the type~type11 will automatically be CHECKED ON ? (It won't only check for Type 1 until 4)
2. If I actually have 3 different categories of TYPE, For example, TYPE1~3, then LEVEL1~3, CLASS1~3, how do I put these different categories back as columns after this? (not under one column but 3 columns)