Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Hi everyone,

I have a simple thing but Zapier runs into an error. A litte bit more context:

 

I have a Pipedrive list with deals that are closed by partner. I want to calculate the commission automatically and added some fields in Pipedrive for it. This all works fine.

Now, for convenience reasons, I simply want to add the Deal Link in the Excel spreadsheet aswell to quickly navigate to the corresponding deal in Pipedrive right from Excel. 

If I add the link in the table like below, the link is posted in the Excel file but its not “clickable”. You have to manually enter the cell and press enter to activate the deal link.

 

So I looked up the =HYPERLINK function and changed the Deal Link accordingly:

 

But now the zap runs into an error:

 

I did a test: If a add a blank space before the equals sign, the zap works and pastes the formular in the cell but it is not working because of the blank space, obviously 🙂. So I guess it has something to do with the equals sign. But I can’t figure out how to solve it.

Looking forward for your help :-)

Thanks,

Maunuel

Hi there @Manuel Renz,

Welcome to the Community! 🎉

I did some digging into our notes, and it seems like this is the correct format of the hyperlink formula.

For Excel to correctly format a hyperlink, the formula needs to be formatted as follows in the editor:

=HYPERLINK("url","text")

Example:

example

Hopefully, this helps! 😊

Hi there @Manuel Renz,

Welcome to the Community! 🎉

I did some digging into our notes, and it seems like this is the correct format of the hyperlink formula.

For Excel to correctly format a hyperlink, the formula needs to be formatted as follows in the editor:

=HYPERLINK("url","text")

Example:

example

Hopefully, this helps! 😊

Ehm, this is exactly how I formatted it, haven’t I?
Or do I need to put the URL in a dynamic field aswell?

How do I do that?

Hi @Manuel Renz,

I looked at the code in the screenshot, and it appears that there might be a small typo in your formula. Instead of using a semicolon, could you please try using a comma instead?

36c161720b7e873684a3193074becd5e.png
(view larger)

Please give that a try, and keep us posted! 😊

Hi @ken.a,

I’m sorry for my dumbness… of course it works now. Sorry for wasting your time!


Best,

Manuel

Hi @Manuel Renz,

No need to apologize at all! We're here to help, and sometimes these things happen. I'm glad to hear that it's working now.

If you have any other questions, please don’t hesitate to post them in the Community. We’re always happy to help! 🤗

Thank you for your understanding. How would Bob Ross say: Happy little accidents! :-)

Reply


Terms & Conditions