Form Question

Hi there! I am trying to use a form to capture data from several facilities that needs to roll up into one dashboard. The initial audit applies to a unit that should roll up to a hospital and then to an overall enterprise. I'm having trouble figuring out how to use a form to complete that. Any insight would be greatly appreciated!

Answers

  • James Keuning
    James Keuning ✭✭✭✭✭

    Either your users will need to add their Enterprise and their Hospital, or you will need to hardcode that data into the form fields (the latter option requires you to create one form for each iteration of these pairs.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!