Adding Link Based on Assigned User


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 ✓

    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", "", IF([Assigned To]@row = "Reggie Andaya", ""))

    Does that make sense?



  • Reggie Andaya
    Reggie Andaya ✭✭✭
    Answer ✓

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