Hi all, Please see the screenshot below - I’d like to display a message in the Is Absent Today column if today’s date is among the dates in Absences. Currently I’m using the following formula but it only works if there’s a single date: IF(DATETIME_DI...

Hi, I’ve spent hours on this and I’m not sure what I’m doing wrong. Here’s what I’d like to accomplish: Each row in the table is a person (a child in daycare)I want to automate a way to change the location of their daycare on a certain dateI have the...

Hi, I’m using the following formula in the column “is absent today”, but for some reason it isn’t correctly finding August 16th. I suspect this is because the linked “Absent” field is an array, which is why I included the &"" in my formula, but that ...

Hi, I’m trying to set up a sheet to manage attendance for a preschool center. Kids have a different “weight” depending on their age, which I successfully set up. The weighting is used to determine how many kids we can have at once. What I now need to...