Merging 3 fields into one

[RoryF]

Hello All..

I have a Google sheet that has 3 fields for each row - at any one time only one of them will have data in the field.  The sheet has 30+_fields but there are only 3 that I am concerned about here. I want to do something in Appsheet where I can check the value of these 3 fields and for the one that has a value copy the value into a virtual column.  I know that it will involve checking if the value is blank but I don't know how to construct the statement or where exactly to put it (I guess it would go in the Formula for the virtual column..).

Would anyone know how to structure this statement?  

Thanks,

RoryF

[Suvrutt_Gurjar · Accepted solution]

You could try an expression in VC something like 

IFS(ISNOTBLANK(Field 1]) ,[Field 1] , ISNOTBLANK([Field 2]), [Field 2] , ISNOTBLANK([Field 3]), [Field 3])

Assumption: Only one of the three fields is nonblank at a time. All three fields are of same type.

[RoryF]

Perfect - Thanks very much..