List ref Virtual Column Error

[Sirfyaad]

Hi,

I have created two virtual column from one table, but there is a problem, one column is getting "ref list" but the Second virtual column is showing error. The functions of both the Virtual columns are given below.

SELECT(PUTAWAY DETAILS[STICKER PERSON], [Sticker Complete Date] = TODAY())

SELECT(PUTAWAY DETAILS[TABLE PERSON NAME], [ENTRY DATE] = TODAY())

 

[Joseph_Seddik]

As the error is already telling you, your column type contains a reference to one table, but its formula is selecting references to a different table. Both should reference the same table.