Comments

4 comments

  • Avatar
    G Suite Resource Manager

    If it's helps, here is a screenshot of part of the spreadsheet

    0
    Comment actions Permalink
  • Avatar
    Randolph Abelardo

    Hi @G Suite Resource Manager.

    The hyperlink() function is native to GSheets and cannot be converted to HTML directly (which Awesome Table uses). We need to extract or generate the correct GDocs file links on column M. 

    Please see the before vs. after screenshots and this view-replica to see how it was done.

    Click here to learn more about the hyperlinkType keyword.

    Hope this helps.


    - Randy

     

    0
    Comment actions Permalink
  • Avatar
    G Suite Resource Manager

    Randy-

       Thank you SO much, that makes complete sense! I am so grateful! I was at this for quite some time yesterday and getting nowhere. I fixed it in less than a minute once I understood how it worked.

    -Jenn

    0
    Comment actions Permalink
  • Avatar
    Randolph Abelardo

    Glad to be of help, Jenn :) 
    Have a great weekend !

    0
    Comment actions Permalink

Please sign in to leave a comment.