Excellent material, Mr Kanani! About COUNT(CASE) - You need to use NULL instead of 0 an it will work. Its very specific and I do not know why someone would want to use it specifically this way but it is possible.
This is great! :) is there a way to make the image clickable so it will be routed to the actual image uploaded on a drive..? I already created a field like this HYPERLINK(Facebook Link, DIMENSION NAME)... thanks!
update: I tried nesting image function in hyperlink hyperlink(url,image(image url)) still wont show. the formula isn't being flagged as I write it but it won't display anything.
Very cool hack for the table row height, love it :D
Excellent material, Mr Kanani!
About COUNT(CASE) - You need to use NULL instead of 0 an it will work. Its very specific and I do not know why someone would want to use it specifically this way but it is possible.
Excellent. Thank you so much!
You're very welcome!
This is great! :) is there a way to make the image clickable so it will be routed to the actual image uploaded on a drive..? I already created a field like this HYPERLINK(Facebook Link, DIMENSION NAME)... thanks!
I need to know exactly the same thing!
me too
Thank you for this great information it saved my day
Happy to hear that!
Very cool!
Thanks!
Can't I embed a hyperlink inside an image?
I keep trying hyperlink(url, image url)
won't work
update:
I tried nesting image function in hyperlink
hyperlink(url,image(image url))
still wont show. the formula isn't being flagged as I write it but it won't display anything.