I want to generate a report from multiple tables. Its kind of an attendance sheet, One table (StaffList) has all the Employee details with Status (Active and Inactive), we add their Attendances on a daily basis which has details on different tables, I want to check if Employee is not available in either of the tables then mark him P (Present) otherwise mark the status on whichever tables he’s available. For example, if the ID is available in the left table then mark his leave from the mentioned dates, if not then check the other tables.
I tried doing this on Google sheets with formula, but that is taking too much of time and making my AppSheet also slow. If I do it by attaching an excel template then the issue is with the array formula. Google Sheet and Excel has different formulas, I don’t get the results.
Thanks in advance