I have a column for each day of the week. If the value for the column is “Yes”, I’d like a separate column called “Notes” populated with that day of the week:

=IF(Monday=”Yes”,”Mondays”,””)

However, if the Tuesday column also has “Yes”, I’d like to “Tuesday” to appear in the Notes column as well: “Mondays Tuesdays”

A concat with if/then works in Excel, but this formula I have isn’t working on Lists:

=CONCATENATE(IF([Monday]=”Yes”,”Mondays”,IF([Tuesday]=”Yes”,”Tuesdays”,IF([Wednesday]=”Yes”,”Wednesdays”,IF([Thursday]=”Yes”,”Thursdays”,IF([Friday]=”Yes”,”Fridays”,IF([Saturday]=”Yes”,”Saturdays”,IF([Sunday]=”Yes”,”Sundays”,””))))))))

Is this formula possible on Lists? What am I missing? Thanks!

​I have a column for each day of the week. If the value for the column is “Yes”, I’d like a separate column called “Notes” populated with that day of the week: =IF(Monday=”Yes”,”Mondays”,””) However, if the Tuesday column also has “Yes”, I’d like to “Tuesday” to appear in the Notes column as well: “Mondays Tuesdays” A concat with if/then works in Excel, but this formula I have isn’t working on Lists: =CONCATENATE(IF([Monday]=”Yes”,”Mondays”,IF([Tuesday]=”Yes”,”Tuesdays”,IF([Wednesday]=”Yes”,”Wednesdays”,IF([Thursday]=”Yes”,”Thursdays”,IF([Friday]=”Yes”,”Fridays”,IF([Saturday]=”Yes”,”Saturdays”,IF([Sunday]=”Yes”,”Sundays”,””)))))))) Is this formula possible on Lists? What am I missing? Thanks!    Read More

​