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 information? π | 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 information? π | 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 information? π | 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 information? π | Help and Learning Center
γγγ«γ‘γ― (Konnichiwa), Hallo, Hola, Bonjour, OlΓ‘, Ciao!π | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.7K Get Help
- 438 Global Discussions
- 152 Industry Talk
- 497 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 509 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 36 Webinars
- 7.3K Forum Archives
Trending in Smartsheet Basics
- Hi Everyone, I would like to create a weekly trivia game for my team members and my thought was to use a form to populate answers to the sheet. However, I don't want them to be able to see what other β¦
- Good afternoon, In reviewing the question that Nino Chkhikvadze posted on 7/30/20, and the response from Andree Stara, Community Champion, on the same date, would it be accurate to say that an unlicenβ¦
