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
-
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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Actually this makes more sense and is alot easier to filter. Thank you for this tip. I did not think about this route.
Answers
-
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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Thank you.
-
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?
-
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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Actually this makes more sense and is alot easier to filter. Thank you for this tip. I did not think about this route.
-
Awesome! I'm glad that helps 🙂
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 466 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives