Surveying Project - How to setup the structure of Smartsheets

I need to send out Architectural Survey team out to the field to survey the existing conditions of a restaurant. Information gathered is Electrical Information (Panel Size, # of Breakers), Equipment (Make Model and serial#), Condition of Walls,etc. I'd like to send them with a Ipad with a Smartsheet form, but I'm overwhelmed on how to setup the sheets.

Is there a preexisting Template like this? something I can edit to match my needs.

Find more posts tagged with

Forms

Templates

Construction

Sheets

Real Estate

Services

Comments

Andrée Starå

Hi Tom,

Yes, there probably is. I'll get back to the post when I find the one I'm thinking of.

Hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Andrée Starå

Would this one work/help?

https://www.smartsheet.com/marketplace/templates/telecommunications-maintenance-list

Do you have anything you're using today? It might be easier to use that and create something new.

Tom Noonan

Thanks Andree for your Help. I'm a beginner to Smartsheets and we had a app being built it never got off the ground. Attached is a picture of the information I want the survey team to capture, but I keep getting mixed up with what data goes in columns versus what goes in rows. I'd like the surveyor to go out to the field pick the client they are working on and input the utilities for the building and then capture the equipment's make model and serial number and condition. Am I biting off more than I can chew?

See the attached Form of the utilities and the form we used for capturing the assets (Manually).

Thanks in Advance!

Asset Capture Sample Form.jpg

Utilities Sample Form.jpg

Andrée Starå

Happy to help!

Smartsheet is perfect for your need.

If you'd like I'd be happy to have a chat about what would work best for your business.

Please e-mail me at andree@workbold.com and well take it from there.

Have a fantastic day!

Best,

Andrée

Andrée Starå

The sheet would look very similar to your screenshot and then we could either have the information in the sheet already or use a form or a combination to collect the information on site. If it made sense, we could use barcodes/QR codes to identify the equipment. Take pictures and attach them to the record in Smartsheet and so much more...

Tom Noonan

I like the idea of using forms in the field and populating a spreadsheet, but I read some where that you can't use one form linking to multiple sheets. Is that true? Because I figure I would go out to the field and on the form you pick the client from a client spreadsheet and when you input assets you would choose from a separate spreadsheet that has all the common assets. Like a spreadsheet containing only equipment like refrigerators and ovens.

Andrée Starå

At the moment the Smartsheet Forms doesn't have two-way communication, but when you open the form, you can select from a drop-down list or similar.

Would it work that the people on the field had the application installed because that might be the better solution by the sounds of it?

It could probably work with forms as well, but I would need more details on the structure and how it could be set up to work best.

Hope that helps!

Andrée Starå

Did you get it working or do you still need help?

Have a fantastic week!

Best,

Andrée

Sign in to join the conversation!

Quick Links

Trending discussions

Monthly feedback from multiple individuals
Hello community, I need help figuring out how to set up a sheet to collect monthly comments on several projects. Each project is assigned to a different person who need to provide monthly feedback on its progress. Ideally, I would like them to receive a reminder notification on the report due date, followed by reminders if…
Sheet shows BLANK rows, there is a "MOVE rows" worflow, is that why?
Is it possible that a workflow that MOVES rows to another sheet too basically do a CUT/PASTE (like in Excel), and then you are left with BLANK rows on your original sheet? I cannot think of any other LOGICAL reason why this would happen. The users enter the data from an Intake Form, it gets placed onto this sheet. They do…
Sorting not working?
Hi. I have a sheet where I am sorting dates by ascending order. But the sorting functionality doesn't seem to be working. Instead of bringing all items with date values to the top of the sheeting and sorting them in ascending order, it leaves a gap. Is it a result of the "Next Review Due" column containing a column formula…