Multi-Row Approvals

Lee Joramo
Lee Joramo ✭✭✭✭✭✭
edited 12/09/19 in API & Developers

I want to migrate an existing SharePoint InfoPath form to SmartSheet. The form is a Budget Request Form.

  • Staff can submit a budget request with arbitrary number of  items (rows)
  • Via a workflow, each item is Approved or Denied.
  • Via a workflow, the entire Request is Approved, Partially Approved, or Denied.

The thing that I am trying to figure out is how to group a set of rows together for collective approval. Any suggestions how to structure this in SmartSheet is greatly appreciated.

Here is an annotated screen shot of the current SharePoint form.

Note: I am planning on building a custom  webform for this via the API, so that Staff will have a similar experience submitting requests, and not need to learn the details of SmartSheet.

firefox_2018-10-11_08-59-44.png

Comments

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    edited 10/11/18

    Hi,

    I can think of a few ways to set this up!

    It might make sense to set it up as a template or sheet instead. But it depends in large on your specific use case.

    I would recommend that you also take a look at third-party tools like WebMerge, DocuSign or similar.

    How many requests per month approximately?

    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.