IF formula to combine rows if checkbox checked

IFCC
IFCC ✭
edited 12/09/19 in Formulas and Functions

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:
· Share on FacebookShare on Twitter

Comments

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭
    edited 02/23/18

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

    · Share on FacebookShare on Twitter
  • IFCC
    IFCC ✭

    Thanks, that will give me something to work with.

     

    Mike

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!