IF formula to combine rows if checkbox checked

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

Find more posts tagged with

Manufacturing

Formulas

Comments

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

Sign in to join the conversation!

Quick Links

Trending discussions

seeking VLOOKUP or equivalent, search for most recent value, multiple dropdowns
My product/use case: I seek to build a camera inventory. Each camera has a unique identifier. Cameras are mobilized to different locations on different days. I need help making a VLOOKUP or equivalent combination of formulae functions to run 2 queries cross-referencing 2 grids, searching a column with multiple dropdown…
Getting error message in approval email
Hey, Is anyone else facing this issue in the approval notifications sent through smartsheet
Add Package Count Based on Customer
I have a sheet with a list of customers in one column, and then the following columns are City, Monday, Tuesday, Wednesday, Thursday, Friday. I need help with a formula that I can put in my sheet summary so that if the customer column says Staples (It can say this in multiple rows) that it will tell me the total package…