I know this is example is from excel but I'm wanting to use this in smartsheet.
I need formula help! In the chart below I need a formula that will look at the information and display them in numerical order and ignore the blanks. So example would be if B2=1 then F2=1 and if C2 is blank but D2 is 1 than G2=1. I want them to line up in order with FGH but be able to shift if one of the BCD cells is blank. Ideally this list would be long consisting of at least 12 different accounts types and say out of the 12 types only 3 are listed they would be resulted in order ignoring any blanks in between. also I'm hoping the formula can ignore columns in between like the second example. I hope I explained that well enough and any help is appreciated!
Help Article Resources
Check out the Formula Handbook template!