Forum Discussion
MicrosoftAttach a dynamic hyperlink based on environment
Hi there! I hope everyone is doing well. I had a use case where I wanted to attach dynamic hyperlinks based on the environment the file is in. For example, in the dev environment, my excel hyperlink column should take me to the dev URL. For production, it should take me to the prod URL. Is there a way this can be done without creating separate Excel files and statically attaching the URLs based on the environment in each file?
3 Replies
You're probably looking for something like that.
I hope I got it right 🙂
The hyperlink in cell A2 should be kept dynamic - relative to the path of this workbook.
After moving, cell A1 must be edited with the F2 key so that the recalculation can be carried out.
I would be happy to know if I could help.
Cheers
Nikolino
I know I don't know anything (Socrates)
Aneesh22Hi NikolinoDE , thank you for the prompt response! While I am certainly looking for something like this I need to perform a conditional insert of the hyperlink, something like:
if env = dev
Add Dev URL to cell A1
else if env = prod
Add Prod URL to cell A1
The key problem is there is no way of knowing the excel sheet is downloaded from a dev environment or a prod one (except the request address) since there is no environment identifier in the workbook. However, if it is, I think your cell formula should work smoothly. Thanks a lot!
- Your Welcome
wish you a nice Day
Nikolino
I know I don't know anything (Socrates)
