IF formula to combine rows if checkbox checked
Options
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
Tags:
Comments
-
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, "")
-
Thanks, that will give me something to work with.
Mike
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!