Multiple Check Boxes - Adding Pre-Fix based on checked boxes and join/collect on multiple rows

Jimrny

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!

Smartsheet User 99

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, " - "))))

Smartsheet User 99

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, " - "))))

Jimrny

https://community.smartsheet.com/discussion/comment/325193#Comment_325193

Yes! That is perfect, thank you!