IF, IFS, AND ISBLANK Formula

[Jonesy]

Hello fellow AppSheet users,

I am having some trouble with my formula. I have created a virtual column, its purpose is to show a columns value but only if that column ISNOTBLANK. Can anyone help me get this right please? Here is my current formula. Only the first paragraph is working. 

PS. In any record, only one of the following columns,  will have any value in it(that is the value I am trying to get).

IFS(
(ISBLANK([Seed Variety])), [Crop Planted],
(ISBLANK([Seed Variety])), [Crop Fertiliser Applied],
(ISBLANK([Seed Variety])), [Crop Pesticide Applied],
(ISBLANK([Seed Variety])), [Crop Weeded],
(ISBLANK([Seed Variety])), [Crop Irrigated],
(ISBLANK([Seed Variety])), [Crop Harvested],
TRUE, [Seed Variety],)

IFS(
(ISBLANK([Crop Planted])), [Seed Variety],
(ISBLANK([Crop Planted])), [Crop Fertiliser Applied],
(ISBLANK([Crop Planted])), [Crop Pesticide Applied],
(ISBLANK([Crop Planted])), [Crop Weeded],
(ISBLANK([Crop Planted])), [Crop Irrigated],
(ISBLANK([Crop Planted])), [Crop Harvested],
TRUE, [Crop Planted],)

IFS(
(ISBLANK([Crop Fertiliser Applied])), [Seed Variety],
(ISBLANK([Crop Fertiliser Applied])), [Crop Planted],
(ISBLANK([Crop Fertiliser Applied])), [Crop Pesticide Applied],
(ISBLANK([Crop Fertiliser Applied])), [Crop Weeded],
(ISBLANK([Crop Fertiliser Applied])), [Crop Irrigated],
(ISBLANK([Crop Fertiliser Applied])), [Crop Harvested],
TRUE, [Crop Fertiliser Applied],)

IFS(
(ISBLANK([Crop Pesticide Applied])), [Seed Variety],
(ISBLANK([Crop Pesticide Applied])), [Crop Planted],
(ISBLANK([Crop Pesticide Applied])), [Crop Fertiliser Applied],
(ISBLANK([Crop Pesticide Applied])), [Crop Weeded],
(ISBLANK([Crop Pesticide Applied])), [Crop Irrigated],
(ISBLANK([Crop Pesticide Applied])), [Crop Harvested],
TRUE, [Crop Pesticide Applied],)

IFS(
(ISBLANK([Crop Weeded])), [Seed Variety],
(ISBLANK([Crop Weeded])), [Crop Planted],
(ISBLANK([Crop Weeded])), [Crop Fertiliser Applied],
(ISBLANK([Crop Weeded])), [Crop Pesticide Applied],
(ISBLANK([Crop Weeded])), [Crop Irrigated],
(ISBLANK([Crop Weeded])), [Crop Harvested],
TRUE, [Crop Weeded],)

IFS(
(ISBLANK([Crop Irrigated])), [Seed Variety],
(ISBLANK([Crop Irrigated])), [Crop Planted],
(ISBLANK([Crop Irrigated])), [Crop Fertiliser Applied],
(ISBLANK([Crop Irrigated])), [Crop Pesticide Applied],
(ISBLANK([Crop Irrigated])), [Crop Weeded],
(ISBLANK([Crop Irrigated])), [Crop Harvested],
TRUE, [Crop Irrigated],)

IFS(
(ISBLANK([Crop Harvested])), [Seed Variety],
(ISBLANK([Crop Harvested])), [Crop Planted],
(ISBLANK([Crop Harvested])), [Crop Fertiliser Applied],
(ISBLANK([Crop Harvested])), [Crop Pesticide Applied],
(ISBLANK([Crop Harvested])), [Crop Irrigated],
TRUE, [Crop Harvested],)

[Marc_Dillon · Accepted solution]

---

@Jonesy wrote:

In any record, only one of the following columns,  will have any value in it(that is the value I am trying to get)

---

ANY( LIST( [col1],[col2],.... ) - LIST("") )

[Jonesy]

Thanks Marc that worked perfectly!! Ill use that one again!!

Kind regards,

James