Adding Link Based on Assigned User

Reggie Andaya

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.

Genevieve P.

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

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

Genevieve P.

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

Thank you.

Reggie Andaya

If there are 2 people listed in the assigned column, how would I modify the code to add links to each users sheet in the Link User Sheet column?

Genevieve P.

Hey @Reggie Andaya

Before we go down this route, can I clarify what URL you're looking to surface? It seems like these are Smartsheet Reports that may be filtered for each person, is that correct?

If so, it would likely be easier to have just one Report built, but use the "Current User" filter so that whoever is looking at the Report sees rows where they are assigned automatically 🙂 That way you can display the same URL for all rows but have it auto-filter based on who clicks on it, does that make sense?

Here's more information: View assigned tasks from multiple sheets

Cheers,

Genevieve

Reggie Andaya

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

Genevieve P.

Awesome! I'm glad that helps 🙂