Automatically enter category into cell

Automatically enter category into cell

Sorry, I do not know how to say this.  I would like to see if there is a way to automatically enter the category name into a cell. (see image) I've manually put the category in the highlighted box but I'd like to see if there is a faster way?

 

Thank you

Smartsheets formula help.png

Comments

  • Andrée StaråAndrée Starå ✭✭✭✭✭
    edited 11/11/19

    Hi Elgia,

    There are several different ways to structure it. Here's one.

    To get the Parent on other rows than the parent row you can use:

    =PARENT([Category/Video Name]@row)

    If it's on the same row as the parent you can use:

    =[Category/Video Name]@row

    It's also possible to combine them in one formula.

    Let me know if you need it, and I'll give you that formula as well.

    Would that work?

    I hope that helps!

    Have a fantastic weekend!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

    work-bold

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

Sign In or Register to comment.