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

  • Smartsheet User 99
    Smartsheet User 99 ✭✭✭
    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