The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
I use a formula to extract the base domain from a long URL
e.g.,
LEFT(Link,FIND("/",Link,4+FIND("://",Link)))
which will take something like:
'https://www.networkworld.com/article/3202753/data-center/data-center-startup-offers-compute-colo-at-cell-to...
It would be awesome to be able to restrict a search to a single column. I can think of two good ways to do this: (1) add an option on the column drop down and (2) add search command like in:column-name.
Also, it would be equally awesome to be able to...
That is terrific. I never would have figured that out on my own. Also, I never realized you could structure formulas across multiple lines for readability!
(Quick note: There is a missing comma at the end of line 2)
It’s too bad you can’t wrap those formulas in an IF/ISERROR and format them as a date. E.g.,
IF(ISERROR(DATEADD({Publication Date},-14,‘days’),’’,DATEADD({Publication Date},-14,‘days’))
This would allow for the draft date calculations to not show #ER...
I am trying to solve the same problem. I am exploring IFTTT and Zapier as ways to trigger an email from a 3rd party app. I agree it would be better to have it fully integrated, as it is in Google Forms.