IF formula to combine rows if checkbox checked

IFCC

Is there a way to do this?

I would like my Primary Column (Task Name) to combine it's text with my 'assigned to' column if the condition of the checkbox in column 'Show' is checked.

thanks

Mike

Mike Wilday

This is doable if you want to set the formula in your primary column and adjust the formula each time you enter it the title of a task.

=IF([Checkbox Column]24 = 1, [Assigned to]24 + " - ", "") + "Task Name"

To set each task name you'd have to come in and edit the formula with your actual task name. 

Or you could reverse it... 

="Task Name" + IF([Checkbox Column]24 = 1, " - " +[Assigned to]24, "") 

IFCC

Thanks, that will give me something to work with.

 

Mike