Comments

4 comments

  • Avatar
    G Suite Resource Manager

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

  • 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

     

  • 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

  • Avatar
    Randolph Abelardo

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

Please sign in to leave a comment.