SumIfs Formula is not working out.. Trade1:Trade5, "Demo", Cost1:Cost5

I am really struggling with the following formula.. Below is the list of my columns of data that comes in automated into a sheet, by way of a webform I have about 50 trades, like (demo, framing, electrical, plumbing etc).....I want my formula to reference the trade column, and pick up only the entries for "framing" to date and tally up the cost.during the project duration.. My guess is I have to build separate forms for each trade..... New entries come in each day....so it needs to sum automatically.... With Excel, its easy to build a pivot table with all of the data, but thats not what i am after....I have a dashboard for each project......and one widget is the P/L for the Job so the field managers can plug in data real time.....(not our accounting system) so this allows us to see real time where we are with cost.....

Line Item Date QB Category Trade Check # Cost Labor/Sub/Vendor Job Notes

Find more posts tagged with

Construction

Comments

Paul Newcome

First: You do NOT have to create new forms for each trade. You can have the trades listed in a dropdown box if the rest of the information is going to be universal.

Second: It seems like there are specific dates you also want to reference ("during the project duration"). Is that something you need factored in as well?

Sign in to join the conversation!

Quick Links

Trending discussions

Document filtered by form responses
I've created a Smartsheets form. When someone submits the form, I want them to automatically be emailed a document that has resources and links, but the document is filtered to only show the content that corresponds with what they selected in the form. Is something like this possible? What types of documents or automations…
Form stopped working after upgrade
I have a sheet that I created in a previous version, and it had a form. I was recently upgraded to a newer version and now my form is not working. I created a new form for the sheet, and it is giving me an error also. Does anyone know what I can do to fix this? The error says Form Unavailable. Sorry, the form you're trying…
Getting Error About Emulated Environments
Hi, I have read the post from 8/21/25. I am still getting the same error. I am setting up a new device and just download the latest version as of 9/5/25. I am using a Eunivon Smart White Board for touchscreen capability. It is running Android 14. Any help would be appreciated.