Forum Discussion
MicrosoftAttach a dynamic hyperlink based on environment
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)