Checkboxes and a formula : Is there a way to...?


#1

I’m feeling very ashamed of myself for asking (because I’m pretty sure I’m just missing something very simple, as it often happens to me :sweat_smile:)…

The situation is :
On one of my [Table], I’ve got 7 checkboxes : {Day 1}, {Day 2}, {Day 3}, {Day 4}, {Day 5}, {Day 6}, {Day 7}.

These checkboxes are just meant to tell me is something is happening that day (Checkbox= checked) or not (Checkbox= unchecked).
Nothing to fancy there :wink:.

What I want to do, is creating another field on the same [Table] that could tell me what {Day} has been checked.

For example:
If {Day 1}, {Day 2} and {Day 5} have been checked, this field (let’s call it {Days}) would tell me something like :
=> {Days} : {Day 1},{Day 2},{Day 5}

I’ve searched and quickly found Using checkbox fields in formulas in the Airtable Support which is pretty simple and works if there is only one checkbox.

IF({Day 1}=1,"Day 1","")

What I’m not able to do, is to find the right formula that could put together all the IF()

IF({Day 1}=1,"Day 1","")
IF({Day 2}=1,"Day 2","")
IF({Day 3}=1,"Day 3","")
IF({Day 4}=1,"Day 4","")
[Etc...]

I thought of using an ARRAJOIN() function, but well, I’m just stuck there… :sweat:

Can someone guide me through this ? :slightly_smiling_face:

Thank you very much in advance :smile::+1: !


#2

Guess what @Ptt_Pch… you can use conditionals in the midst of a concatenation! I’ll not give you the whole formula, for time’s sake, but it should be enough for you to see what’s going on and finish it out:

IF({Day 1} = 1, "Day 1, ") &
IF({Day 2} = 1, "Day 2, ") &
...

Another way to do that is:

CONCATENATE(
   IF({Day 1} = 1, "Day 1, "),
   IF({Day 2} = 1, "Day 2, "),
   ...
   )

Make sure you have the space after the comma inside the string each conditional produces (except for the “Day 7” one, which will have no comma) for proper spacing.


#3

Thank you very much @Jeremy_Oglesby :grin: :+1:

That’s exactly what I was looking for but couldn’t find :sweat_smile: !