Pull data into a virtual column for a list.

[EAHendrix]

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]

)

[Marc_Dillon]

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...