Thank you @Lydia and @bojanvelevski for your help on this one. As I can only mark a single comment as a solution, I wouldnโt do justice to one of you but without both of you, this thread wouldnโt have been concluded.
Thank you @Lydia for providing the formula for hyperlink "=HYPERLINK(\"https://www.google.com\",\""+$ID+"\")" and letting me know that a manual intervention in excel would be needed to just go over that cell and click โEnterโ for the formula to work.
Thank you @bojanvelevski for sharing the workaround of using a CSV Formatter instead of an Excel Formatter, that solution really helped although it does have a manual intervention but lesser than the one stated above (by going into each cells and activating the formulas)
Iโm marking this as a solution intentionally so that I can give credits to both of you and anyone referring to this thread can get best of both the worlds in a single comment.
Thank you!
Signing off from this thread as workaround will do the trick for now.
Best Regards,
DT
P.S. Doesnโt mean that I donโt appreciate your efforts and wanted to offend either of you.
CC: @dmiller @robin
#multiplesolutions #creditsharing
