This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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.
