Skip to main content

How can I get column names and fill those in?

  • April 9, 2018
  • 3 replies
  • 33 views
N

Hello. I have a table with the days of the week:

Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday

I have a following column with “Schedule”

If I have something in Sunday, Monday, and Tuesday, how can I get the “Schedule” column to automatically list “Sunday, Monday, Tuesday”?

I can do this in Excel accessing the name of the column, but, how do I do this in AirTable?

    3 replies

    N
    • Nick_Burrus
    • Author
    • Participating Frequently
    • April 9, 2018

    One thing I thought about was a formula to do it.

    “IF(Sunday, “Sunday”, “”),IF(Monday, “Monday”, “”)”

    But I don’t know how to get multiple IF statements.

    W
    Forum|alt.badge.img+5
    • W_Vann_Hall
    • Inspiring
    • April 9, 2018

    One thing I thought about was a formula to do it.

    “IF(Sunday, “Sunday”, “”),IF(Monday, “Monday”, “”)”

    But I don’t know how to get multiple IF statements.


    You’re on the right track. In this case, though, you probably don’t want a nested IF() statement but you want to concatenate several IF() statements:

    IF(Sunday,'Sunday')&
IF(Monday,'Monday')&
IF(Tuesday,'Tuesday')&
IF(Wednesday,'Wednesday')&
IF(Thursday,'Thursday')&
IF(Friday,'Friday')&
IF(Saturday,'Saturday')

    That’s almost it, but that would give you, for instance

    SundayTuesdayWednesdayFriday

    So we’ll first place a space after each day name; then we’ll trim off any trailing spaces; and finally we’ll replace the remaining, between-day spaces with a comma-space pair, like so:

    SUBSTITUTE(
    TRIM(
        IF(Sunday,'Sunday ')&
        IF(Monday,'Monday ')&
        IF(Tuesday,'Tuesday ')&
        IF(Wednesday,'Wednesday ')&
        IF(Thursday,'Thursday ')&
        IF(Friday,'Friday ')&
        IF(Saturday,'Saturday')
        ),
    ' ',
    ', '
    )

    Now you’ll get

    Sunday, Tuesday, Wednesday, Friday

    or the like.

    J
    N
    N
    • Nick_Burrus
    • Author
    • Participating Frequently
    • April 9, 2018

    You’re on the right track. In this case, though, you probably don’t want a nested IF() statement but you want to concatenate several IF() statements:

    IF(Sunday,'Sunday')&
IF(Monday,'Monday')&
IF(Tuesday,'Tuesday')&
IF(Wednesday,'Wednesday')&
IF(Thursday,'Thursday')&
IF(Friday,'Friday')&
IF(Saturday,'Saturday')

    That’s almost it, but that would give you, for instance

    SundayTuesdayWednesdayFriday

    So we’ll first place a space after each day name; then we’ll trim off any trailing spaces; and finally we’ll replace the remaining, between-day spaces with a comma-space pair, like so:

    SUBSTITUTE(
    TRIM(
        IF(Sunday,'Sunday ')&
        IF(Monday,'Monday ')&
        IF(Tuesday,'Tuesday ')&
        IF(Wednesday,'Wednesday ')&
        IF(Thursday,'Thursday ')&
        IF(Friday,'Friday ')&
        IF(Saturday,'Saturday')
        ),
    ' ',
    ', '
    )

    Now you’ll get

    Sunday, Tuesday, Wednesday, Friday

    or the like.


    Thank you! That is brilliant! & modifier! I learned something new today!

    Terms & ConditionsAccessibility statement