How to If-then-else—> array?

[S_C]

everyone!

I need help. I am trying to convert multiple if-then-else to array(for example, pic 1, pic 2, pic 3-> pic array). As if-then-else columns don’t sync back to Google Sheet, I am struggling.

Btw, shouldn’t ITE1, ITE2-> ITE array?

Anyone who solves the problem gets a reward of 1 million thanks.

[Jeff_Hager]

You can’t create an array column with glide columns like you can with Google sheet columns. You would have to do your IF THEN statements in the Google sheet instead. Not sure why, but that’s been my experience.

[S_C]

I agree. I did and the problem is when I deleted the top row those were all gone. Since syncing functions in google sheets are not optimal for Glide and glide users, I wanted to see if there is a native glide solution?

[Jeff_Hager]

To fix your problem with the formula being deleted, you should actually make it part of your headings, or in my case I usually have 2 header rows. One with the heading and one with the formula. I have my formulas structured so nothing actually shows in the second row and Glide ignores it.

Here is some more info on structureing the header with the formula.

@ThinhDinh

3.2. Keep the arrayformula in the headers

Instead of putting the arrayformula in row 2 where the data starts, you can put it in the header and never have to worry about accidentally delete that row ever again.

This formula below would create an array, populating the first cell with the header name, and the arrayformula starts from below that.

={"Order value";ARRAYFORMULA(IF(A2:A<>"",A2:A*B2:B,""))}

[S_C]

Thanks @Jeff_Hager! Very helpful. Can you think of some way to help me with glide native solution as well. I know you can! I tried for 3 hours and didn’t get anywhere.

Here is the problem rephrased:

There are text only columns which contain target text. I need glide to identify one part per column and these columns should make an array so that I can create and inline list.
Previously, I had created Boolean columns in sheets that I would manually ‘switch on’/ mark ‘TRUE’ so that another column in an array would write the keyword leading to a relation and thus leading to an inline list in glide. I am trying to avoid the manual ‘switch on’ using sheets.

If you can’t think of a solution, I understand and thank you for thinking.

If I am not clear in explaining the problem, please let me know.

[Coupons_Deal]

@S_C What is your business case or purpose for this?
Not a solution but you can create equivalent template/relation-lookup… column to sync back your data to googlesheet. Haven’t tried just a vague imagination.

[Coupons_Deal]

Can you quote with example/demo? Not entirely clear for me.

[S_C]

Tried lookup, join, and template. None of these sync back to google sheets

[S_C]

Let me elaborate the case scenario in the morning as it’s a bit complicated to write at 3 am . Btw, thanks for helping me.