Hey all,
I have an interesting ask. My company uses sheets we call Roster files to organize HCP Contracts for Medical Events. The request from my team is to have a column in these roster files that populates with a link to the roster file they are already in.
Why? We've drafted reports to organize all HCP contracts grouped by various filters (Coordinator, Entity, Therapeutic Area Etc.). It would be convenient to have a link to the Roster sheet itself to edit some of the fields in the Roster that do not play well in reports (Some of it is vertically oriented rather than horizontally like SS likes, so the variance in data in certain columns renders them useless in some instances). What they do now is have a Medical Event Master Tracker open which contains the links to the individual Roster sheets along with high level data pertaining to the given event. That sheet is incredibly slow and cumbersome to use (despite aggressive archiving), so we are looking for alternative solutions.
My first thought, of course, was index/match the ID tag on the Master Tracker, but that will not return the link, just the text. TBH I have no idea where to begin with this and think it might be a nonstarter period. Maybe using an API to leverage scripting or something but that's a bit beyond my current capabilities, let alone time constraints.
Any and all ideas are welcome... how do you autogenerate a link in a sheet to itself? lol
I'm thinking... these RFs need to be manually created (until I have time to set this workspace up in control center)... I'll probably just have to manually copy/paste the url at the top all the way down the column where the HCP rows are. Not ideal, obviously, but maybe my only/best solution for now.
