Keep track status of a monthly fix work

[msyamil]

Hi everyone, 

So basically every month, our team have a fix task to do. For example: doing stock count and report it in the spreadsheet. I am trying to automate the process, by having everyone to submit their data via the Google Form, which later updated to Spreadsheet.

I am wondering if there is a way for the Looker Studio to show who haven't submit the data yet? I know Looker mainly to show what data it has, but is there any way to show when a data is absent?

Thank you.