Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Template for videos and notes in spreadsheets to output docs code
=IF(ISBLANK(F5),"", B5 & CHAR(10) & "^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^" & CHAR(10) & TEXT(A5, "mmmm d yyyy") & " a "& D5& " by " & E5 & CHAR(10) & CHAR(10) & IF(ISBLANK(F5),"", Concat("`Video <https://www.youtube.com/watch?v=", Concat(F5, ">`__, "))) & IF(ISBLANK(G5),"", Concat("`Author slides/docs <", Concat(G5, ">`__, "))) & IF(ISBLANK(H5),"", Concat("`Collective notes <", Concat(H5, ">`__, "))) & CHAR(10) & CHAR(10) & C5 & CHAR(10) & CHAR(10) & CHAR(10))
@natbat

This comment has been minimized.

Copy link
Owner Author

@natbat natbat commented Sep 29, 2015

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment