Automatically enter category into cell

Elgia
Elgia
edited 12/09/19 in Formulas and Functions

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

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!