#### Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

# Using Smartsheet with a Windows 10 touch screen PC

Options
✭✭✭
edited 12/09/19

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.

Tags:

• Employee
Options

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.

• ✭✭✭✭✭✭
Options

Hi,

I have a workaround that might help.

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

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

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

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

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

This discussion has been closed.