Using a hyperlink to a Thumbs up if 100% is achieved. Or if not a thumbs down.
Hi , I have created a progress chart where each week participants record a number in one cell and the next cell automatically converts that number to a percentage of the progress made, as in the mock up below:
Ben 0 0.0% 17 9.7% 128 72.7% 176 100.0%
Bob 57 32.4% 71 40.3% 96 54.5% 124 70.5%
Bill 1 0.6% 3 1.7% 74 42.0% 113 64.2%
Brad 0 0.0% 19 10.8% 42 23.9% 160 90.9%
Brian 130 73.9% 152 86.4% 176 100.0% 176 100.0%
I need to add some fun ton this task so I’d like to add another cell that say “Click to check progress” Then only when the formular can see a 100% it will open a hyperlink to a Thumbs Up and a message pops up with “Fantastic You Have Finished”.
But if there is not a 100% in their row then when the cell is clicked, the hyperlink is to a Thumbs Down and a message “Your nearly there keep going”.
I have tried this but it is not even valid. Plus others and nothing works.
=IF($D$11:$J$11="*100", HYPERLINK("#$$D$11:$J$11", "Click here to check progress"), "#"&$D$11:$J$11)
If anyone has had success with this could you help, it would be awesome.
Hi , I have created a progress chart where each week participants record a number in one cell and the next cell automatically converts that number to a percentage of the progress made, as in the mock up below:
Ben 0 0.0% 17 9.7% 128 72.7% 176 100.0%
Bob 57 32.4% 71 40.3% 96 54.5% 124 70.5%
Bill 1 0.6% 3 1.7% 74 42.0% 113 64.2%
Brad 0 0.0% 19 10.8% 42 23.9% 160 90.9%
Brian 130 73.9% 152 86.4% 176 100.0% 176 100.0%
I need to add some fun ton this task so I’d like to add another cell that say “Click to check progress” Then only when the formular can see a 100% it will open a hyperlink to a Thumbs Up and a message pops up with “Fantastic You Have Finished”.
But if there is not a 100% in their row then when the cell is clicked, the hyperlink is to a Thumbs Down and a message “Your nearly there keep going”.
I have tried this but it is not even valid. Plus others and nothing works.
=IF($D$11:$J$11="*100", HYPERLINK("#$$D$11:$J$11", "Click here to check progress"), "#"&$D$11:$J$11)
If anyone has had success with this could you help, it would be awesome.
