Multiple Check Boxes - Adding Pre-Fix based on checked boxes and join/collect on multiple rows
![Jimrny](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
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!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives