I'm trying to create an absence App in AppSheet using PTO Tracker template, this template generate a table with the following columns:

  • Unique ID
  • Employee Name
  • Start Date
  • End Date

enter image description here

My actual version of Absence sheet have a table with all months dates on all raws and Employee names in columns, and under every name on every row ther's a check box to assign a work and a red background for absence.

What I'm trying to do is to automate the conditional formatting based on the sheet created from AppSheet.

In need to made some cecks for every updated absence, but right now I've not found the right formula to made it work:

  • Name check from the list to the absence table
  • Date check for the red background in the corresponding worker and dates between the absence list

Like the image below

enter image description here


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.