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
Comments
-
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?
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 142 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives