I have a project in which I am needing to determine if a form has yet to be completed. On one tab, I have a list of all assigned ID codes (referred to as 'All' tab). On another, I have a large running-list of the completed ID codes thus far (referred to as 'Dataset' tab).
I have used this formula within a table on the All tab: =MATCH([@[ID Code]], Dataset[@ID Code], 0)
The result is a mixture of #N/A (total of 727 items), #VALUE! (total of 2488 items), and 1 (only 1 item).
Both columns are in number formatting.
How can I mark which forms have been completed thus far with in my table on the All tab?
Comments and suggestions are welcome!
Thank you,
Sarah
I have used this formula within a table on the All tab: =MATCH([@[ID Code]], Dataset[@ID Code], 0)
The result is a mixture of #N/A (total of 727 items), #VALUE! (total of 2488 items), and 1 (only 1 item).
Both columns are in number formatting. How can I mark which forms have been completed thus far with in my table on the All tab?
Comments and suggestions are welcome!
Thank you,
Sarah
