Multiple Check Boxes - Adding Pre-Fix based on checked boxes and join/collect on multiple rows
What is the best way to add a prefix based on the check box being true or not? I have a tracker that I use to refer from to my main roster.
I would like to populate in the notes "Late", "Absent", or "Early Dismissal" if that column is checked, followed by the following:
Late - 03/29/22 - "Detailed Content"
Absent - 03/29/22 - "Details Content"
ect..
I would like to collect and join the notes here.
Thanks!
Best Answer
-
Will there be multiple checked boxes, like the examples shown in the picture? If I read and understood what you were asking for correctly, here is what I have if only 1 of the 3 boxes will be checked.
=IF(Late@row = 1, "LATE" + " - " + JOIN(Date@row:Details@row, " - "), IF(Absent@row = 1, "ABSENT" + " - " + JOIN(Date@row:Details@row, " - "), IF([Early Dismissal]@row = 1, "EARLY DISMISSAL" + " - " + JOIN(Date@row:Details@row, " - "))))
Answers
-
Will there be multiple checked boxes, like the examples shown in the picture? If I read and understood what you were asking for correctly, here is what I have if only 1 of the 3 boxes will be checked.
=IF(Late@row = 1, "LATE" + " - " + JOIN(Date@row:Details@row, " - "), IF(Absent@row = 1, "ABSENT" + " - " + JOIN(Date@row:Details@row, " - "), IF([Early Dismissal]@row = 1, "EARLY DISMISSAL" + " - " + JOIN(Date@row:Details@row, " - "))))
-
Yes! That is perfect, thank you!
