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 r…

ANY( LIST( [col1],[col2],… ) - LIST(“”) )

IF, IFS, AND ISBLANK Formula

Jonesy April 16, 2023, 7:27am 3

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

Kind regards,

James

Topic		Replies	Views
IF Formula not returning the Value AppSheet Q&A ux , admin , databases , expressions	8	2	July 7, 2022
IF Statement Expression AppSheet Q&A automation , databases , expressions	2	0	June 21, 2022
Merging 3 fields into one AppSheet Q&A databases , expressions	2	0	August 19, 2022