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?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 438 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 451 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 282 Events
- 32 Webinars
- 7.3K Forum Archives