Using Smartsheet with a Windows 10 touch screen PC

Is there any way duplicate the capability of some Windows 10 apps to rapidly scroll through data? I have a sheet with about 250 rows and it can take 3 or 4 seconds to scroll down the sheet. Four seconds doesn't sound like much, but if you are demonstrating something in a meeting, it feels like a very long time.

Find more posts tagged with

Sheets

Comments

Travis

Smartsheet has not been optimized for use with touch screen computers but if you have a keyboard attached, you can use the CTRL + G shortcut to go directly to a row in your sheet.

Andrée Starå

Hi,

I have a workaround that might help.

Create a Table of content section in the sheet (at the top)
Create a new column (Count)
Use the following formula in the Count column.

=1 + 0 (Copy down the whole sheet)
Create a new column (RowID)
Use the following formula in the RowID column, cell 1. =COUNT(Count$1:Count@row) (Copy down the whole sheet)
Create a new column (Row)
Use the following formula in the Row column.

="CTRL/CMD+G " + RowID@row
Link the different sections of the sheet to the ToC in the at the top with the following formula. =Row16 (for row 16)
Try it by pressing the CTRL/CMD + G combination and type the number from the ToC section that you want to jump to.
You can also combine the Row and Task Name column and hide the Count, RowID and Row columns.

Please see the attached link/screenshot for more information.

https://cl.ly/d71b0a

Depending on your country you’ll need to exchange the semi-colon to a comma in the above formulas.

I hope this helps you!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting