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