Adding Link Based on Assigned User

Options

I can't determine the best way to do this. So If the Assigned To is assigned, I want a link added automatically to that users specific project summary smartsheet. This sheet below is a high level overview of cases opened for our department but want a link added if someone wanted to view the individual person's smartsheet that shows cases assigned to them directly.


Best Answers

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓
    Options

    Hi @Reggie Andaya

    Do you know all the sheet URLs for each person already? If so, one way to do this would be to use a nested IF statement formula that says "if the assigned to person is X, display X-URL" and so on.

    For example:

    =IF([Assigned To]@row = "Genevieve P", "https://community.smartsheet.com/", IF([Assigned To]@row = "Reggie Andaya", "https://www.smartsheet.com"))

    Does that make sense?

    Cheers,

    Genevieve

  • Reggie Andaya
    Reggie Andaya ✭✭✭
    Answer ✓
    Options

    Actually this makes more sense and is alot easier to filter. Thank you for this tip. I did not think about this route.

Answers