Hi everyone, here's what I'm trying to do. This is a base used to track enrolment in classes.Column 1 (linked values): Enrolment HistoryColumn 2 (linked values): Classes - Current EnrolmentI want an automation that will run every day and add any link...
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...
Hi Justin, thanks for replying - it turns out that the automation was actually working correctly, but it wasn’t clear during the testing process. I thought it would show a before/after.
