Summary Formulas vs Variable Formulas
Not sure which one I need here, or if there is another way of doing this. Have a table with Fire Calls, types are Fire and Ems. I need to show both on a chart, which I have already done. I need a ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendHave you considered doing a stacked bar chart instead? Maybe with the X axis being the date grouped by months. Then make the series the type?
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Just thought of another way to do this. Can I auto create a record that would sum two other records? Meaning, if someone enters a data point for Feb 2024 with call type EMS, then a new record is automatically created with call type monthly total that would add # of calls for EMS+# of calls for Fire?
I say auto-generated, because otherwise I would have to precreate that record, so to speak. I still don't talk correct developer language here, so I am attempting to explain my desires/thoughts from a Manager's perspective.
------------------------------
Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)
IT Director City of New Braunfels
------------------------------
- MarkShnier__You
Where did I lose you?
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------That formula "seems" to accomplish a COUNT of the type of calls. or something I an completely missing. Maybe a screenshot of my table would be helpful here.
I guess I can just accept that the way I need to go here is to add another [Call Type] such as Total and just have the user enter it. I can see where this leads to possible data entry issues, but I just can't work out how I can do it otherwise. I just have a nagging feeling SmartSheet can do this, I just can't figure it out.
------------------------------
Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)
IT Director City of New Braunfels
------------------------------- MarkShnier__You
Can you just try what I suggested and tell me where you get stuck? Just create those three simple formula fields and add those three fields to be on your chart report.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
