If you clic in the F2 cell and then press enter does the formula gets calculated then ?
I’d think this is because the output printed is “text” so it shows the text until you click it and it understand it’s a formula instead. I’m not sure how you could fix this, this has probably to do with excel settings too…
Yes, clicking enter does the trick in excel and I tried to put an excel parser in the pipeline too (as it has the option of calculating the formulas) but the pipeline gets complicated as at the end as we would need to use a combination of mapper, document to binary, parser, etc.
I tried reading the same CSV file (shown in the snap above) and convert it in snapLogic but the hyperlink doesn’t work there, I believe the workaround should do for now, thanks for testing this @bojanvelevski
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.
Signing off from this thread as workaround will do the trick for now.
P.S. Doesn’t mean that I don’t appreciate your efforts and wanted to offend either of you.