Forum Discussion
Concatenate combined with if/then on Lists
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!
1 Reply
Should work with some slight changes. You basically just need to repeat your first line for each work day instead and make sure to add a space, in case it returns multiple days:
=CONCATENATE((IF([Monday]="Yes","Mondays ","")),(IF([Tuesday]="Yes","Tuesdays ","")),(IF([Wednesday]="Yes","Wednesdays ","")),(IF([Thursday]="Yes","Thursdays ","")),(IF([Friday]="Yes","Fridays ","")))If it gives a syntax error, it's usually due to language settings. If your language isn't English, you need to replace CONCATENATE, IF and "," accordingly.
