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!

Find more posts tagged with

Accepted answers

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

All comments

Smartsheet User 99

Jimrny

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

Yes! That is perfect, thank you!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.