I want to reference a Note in a clickable link in google sheets.
I tried two things with getting desired behaviour
1) Right click on note, Copy External link. paste into sheets cell. Almost works, however opens up web version of note
2)Whilst pressing CTRL, do the sames as 1). I get the following my link evernote:///view/29783982/s241/36........
if I paste that in a browser bar, and presser return, i get desired result. However, if I try and paste it into insertlink in google sheet cell - it complains that there is a typo/wrong format.