iOS 13 and SmartSheet

Rick Floyd
Rick Floyd ✭✭✭✭
edited 06/14/22 inAdd Ons and Integrations

For any Apple developers, have you tried the beta version of iPad OS, Safari and SmartSheet? I am so wanting to eliminate carrying my Windows laptop just for SmartSheet administration. The current SmartSheet apps don't allow it and neither does the mobile version of Safari in iOS 12.

Please let me know your experiences so far for tasks beyond just simple updates.

Thanks,

Rick

Tags:
· Share on Facebook Share on Twitter

Comments

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi Rick,

    That would be excellent!

    I'm planning to research remote server solutions so I could have a machine available from any device with the desktop Smartsheet experience, but I sure would love to have it natively on an iPad Pro instead. I'm not sure why it's not possible because the machines are probably powerful enough.

    Have a fantastic week!

    Best,

    Andrée Starå

    Workflow Consultant @ Get Done Consulting

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    https://workbold.com/

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

    W:www.workbold.com| E:[email protected]| P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

    · Share on Facebook Share on Twitter
  • Shaine Greenwood
    Shaine Greenwood Employee

    Hi All—

    Please submit aproduct enhancement requestto let our Product team know that you'd like to have the full browser version of Smartsheet available on iPad.

    · Share on Facebook Share on Twitter
  • Rick Floyd
    Rick Floyd ✭✭✭✭
    edited 06/24/19

    The public beta was released today for both iOS 13 and iPadOS. I am running iPad OS on my 12.9” iPad Pro 2018. It is looking very promising! I can do all my account management and run my templates and forms. I do see some glitches with scrolling. But, this is VERY promising.

    We are taking a family vacation over the 4th and now I know I don’t NEED to bring my laptop. I’ll keep you informed on how it progresses.

    Rick

    · Share on Facebook Share on Twitter
  • Macca350
    Macca350 ✭✭

    I downloaded the iPadOS public beta this morning and tried Smartsheet straight away, as I too would like to reduce carrying my laptop around. It’s so close to working well, it’s just scrolling that gets in the way.

    As it is, if I try to scroll through a sheet, the whole page just moves up and springs back down. I can scroll through the sheet using the arrow keys on the keyboard but that isn’t ideal for big sheets

    · Share on Facebook Share on Twitter
  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Thanks for the update and the promising news!

    Best,

    Andrée

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    https://workbold.com/

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

    W:www.workbold.com| E:[email protected]| P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

    · Share on Facebook Share on Twitter
  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Looks very promising!

    Best,

    Andrée

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    https://workbold.com/

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

    W:www.workbold.com| E:[email protected]| P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

    · Share on Facebook Share on Twitter
  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    How is it working with formulas?

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    https://workbold.com/

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

    W:www.workbold.com| E:[email protected]| P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

    · Share on Facebook Share on Twitter
  • arkitektur
    arkitektur ✭✭

    I am using Smartsheet with an iPad Pro 2018 with iPadOS 13.1.3 (with Safari):

    - We have now much more possibilities than before or with the ios 13 app, but still lightyears behind the win10 browser version ... so if you like to work with Smartsheet, buy a Laptop ... or a surface pro 7 ...

    - the ios app isnt really better since the last update (23. oct. 2019). so i dont exspect that they improve it anytime soon ... sad

    -

    · Share on Facebook Share on Twitter
  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Yes, it's so much better now, and we can do so much more.

    I'm planning on testing other browsers, remote solutions, Android, and Surface to what works best and what the differences are.

    It seems like it works best at the moment on a windows tablet.

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    https://workbold.com/

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

    W:www.workbold.com| E:[email protected]| P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

    · Share on Facebook Share on Twitter
  • Trevor Phelps
    Trevor Phelps ✭

    I am using a 2018 iPad Pro and just recently purchased a 2020 12.9 iPad Pro. I use a Magic Mouse with the IPad which has eliminated my need for a laptop or desktop for the type of work that I do. I am wanting to see if there are any solutions for the scrolling function with the desktop version of Smartsheet. It seems that you can only scroll from the up/down and side to side “bars” on the sheets. Is there a solution that will allow scrolling and movement with the cursor anywhere on the sheet?

    · Share on Facebook Share on Twitter
  • Michael Sundet
    Michael Sundet ✭

    Still not able to scroll on ipad pro... when will this be avalable?

    · Share on Facebook Share on Twitter

Categories

Hey @Julie Fortney<\/a> <\/p>

I'll answer what I can and shout out to @Brian_Richardson<\/a> for back up. <\/p>

#1 Report Filters- To my knowledge there isn't a direct Report Filter update however I wondered if the column was a dropdown list - if so, Bridge can update dropdown lists and if the filter was set to select all it made me wonder if the filter would pick it up new selections. (Datashuttle also updates dropdown lists if this method works)<\/p>

#2 I've had problems with a slow sheet erroring out in Bridge. The sheet was massive and Bridge would time-out. Bridge did not help this sheet (it might have been too large for anything to help)<\/p>

#3 -I don't have any experience with Control Center, so sorry, I can't answer those questions<\/p>

My fav Bridge solutions?<\/p>

-Capturing Approver Names in approval workflows<\/p>

-Adding rows - same sheet, different sheets, Child rows to Parents, On a weekly cadence, Adding New rows of acquired data to a status update sheet which feeds into a dashboard report<\/p>

-Translating Employee Ideas from their native tongue to English<\/p>

-Checking FedEx Tracking Status on a sheet's worth of shipments<\/p>

I hope this helps<\/p>

Kelly<\/p>"},{"commentID":373322,"body":"

Hey @Julie Fortney<\/a> !<\/p>

  1. In general you cannot update reports with bridge or the API, you can only get report information and details. So unless you are able to come up with a different solution you may be out of luck. Although, if this is a control center program, you may be able to use \"Dynamic Reports\" which adds new sheets to reports every time a project is provisioned (and removes as projects are archived). <\/li>
  2. Maybe using JavaScript in bridge would help, hard to say. <\/li>
  3. Unfortunately not.. You can not programmatically retrieve a form link (Big functionality gap in my opinion). We have begged Smartsheet to dynamically update forms with control center. Also you can not update the contents of widgets in dashboards with bridge or the api.<\/li>
  4. You could definitely set up a solution to achieve this. It would involve using a summary sheet in your blueprint where the link to your template sheets is profile data on your summary sheet. From there you can get the sheet id for each project in bridge, loop through them and make updates.<\/li><\/ol>"},{"commentID":373373,"body":"

    @Kelly Moore<\/a> thanks for the shout out :-) but I'm not sure I can help more than what's already been posted. <\/p>

    @Julie Fortney<\/a> in general Bridge is an API tool. You can setup multi-branched workflows in Bridge with pre-set API calls and utilities. You can also do custom HTTP calls to any API that you have access to in the cloud. So anything you can do with API calls you can do with Bridge. It also, importantly, allows you to run Javascript code using the results of your API calls, and to trigger workflows on changes to Smartsheet content or on any other webhook that you can receive from other tools.<\/p>

    There's a fair amount of Smartsheet API methods that are prebuilt into Bridge, but not all of them. So if you're looking at the Bridge documentation for Smartsheet<\/a> integrations and not finding what you need, you can also look at the Smartsheet API documentation<\/a> to see if there's something there to help you out. If you find an API method to use that's not already pre-built as an integration, then you can use the Custom HTTP Call step to directly call the API. You just have to provide the Smartsheet API with an API token, which you can assign to yourself in your Personal Settings.<\/p>

    It looks like your specific questions were answered pretty comprehensively by Kelly and Samuel but here's my 2c:<\/p>

    1. Because you cannot adjust report filters using the Smartsheet API, you cannot do this with Bridge. Here's the Reports methods<\/a>. You might want to consider a workaround for the process of having reports hand-updated with new job numbers. Perhaps leverage a creation date or flag new items with a checkbox that's cleared once the conditions are met that would cause the project to fall back off the report? You can also explore the \"contact has any of current user\" filter to pick up specific jobs for the viewer?<\/li>
    2. You could definitely use Bridge to read one sheet on a schedule or trigger, perform calculations using Javascript or the included utilities, and post the results. It may be faster and more stable than a huge number of formulas in Smartsheet, but I'm not 100% sure it would be. I would probably first explore using Data Mesh, which is setup to do this in a much more friendly way. If you don't already use Data Mesh, it's basically a batch index\/match tool. <\/li>
    3. As Samuel said, there's no API for updating widgets on a dashboard or retrieving a form URL. Also, I tested copying a dashboard and sheet in a common folder, where the form link was embedded in the dash, and unfortunately it does not update the form link. Seems like a gap and would be a good enhancement request. You could potentially work around this by having a common sheet with the form to capture entries, have a dropdown in that form for the project name that you can keep updated with Bridge, do a lookup to the sheet ID that the entry should go to on a sheet that Bridge maintains, and then copy the form responses into the individual project sheets using Bridge. I know that's pretty roundabout.<\/li>
    4. As Samuel and Kelly said, you can push dropdown updates through Bridge, it works better than Data Shuttle. You wouldn't need to maintain a separate lookup sheet though, if you create a report that contains the dropdown columns across your various created sheets, and then read that report with Bridge, the return from the API includes the source sheet ID and column ID for each report row. You can then leverage that to point Bridge at the right columns across your sheets without having to maintain a separate lookup.<\/li><\/ol>

      At Iron Mountain we use Bridge for a variety of use cases, here's the most effective ones:<\/p>