Pull data into a virtual column for a list.

AppSheet AppSheet Q&A
,
1

I have data in my main table that I need to format for a list on a form.

I am trying to pull the data into a virtual column I use for a REF list. I need to check if my date is blank and if it is that the item column is for paper. If it is it pulls the item number. This is what I have tried.

IFS(
AND(
ISBLANK(Inv[Date]),
(Inv[Type]=Paper),

Inv[Item_Number]

)

2

Mostly: “huh?”

But also this should at least help one issue:

https://community.appsheet.com/t/referencing-a-column-value-in-a-table-versus-referencing-all-column-values-in-the-entire-table/50771

1 Like