Hi,
May I know if anyone knows the correct formula for colomn G in sheet 1 in this google sheet please ? :
https://docs.google.com/spreadsheets...jEs/edit#gid=0
So I need to crawl the 'names' and 'Screenshot of Attempt' from sheet 2 & sheet 3 in colomn B & colomn E, which referrerd to the colomn name in sheet 1 colomn B. If it does existed in sheet 2 and/or sheet 3 colomn B & colomn E, then in sheet 1 colomn G should be specified as 'sent'.
Thank You !
Bookmarks