Links from Numbers

  • Resolved mpbaweb

    (@mpbaweb)


    6 years, 8 months ago

    Hi
    I was hoping to enhance my existing tables by adding links to each of the scores in the below page. I can make the links easily enough, but when I do this, the total column (which is the sum of the columns to the left) throws an error as it doesn’t not see the value as a number any more.
    Is there any workaround for this behaviour?

    • This topic was modified 6 years, 8 months ago by mpbaweb.

    The page I need help with: [log in to see the link]

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    thanks for your post, and sorry for the trouble.

    The only way would be to duplicate the column and use the numeric one for calculation, but the other one for the clickable links.

    Regards,
    Tobias

    Thread Starter mpbaweb

    (@mpbaweb)

    So for example I could have columns 1,2,3,4,5 for the links and have hidden columns 6,7,8,9,10 as numbers and SUM(col6:col10) as the total ? Will SUM work on hidden columns?

    • This reply was modified 6 years, 8 months ago by mpbaweb.
    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    correct, that’s the best procedure.

    Regards,
    Tobias

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Links from Numbers’ is closed to new replies.