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 LegendWhere 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
------------------------------I did this. Here is the chart and field properties.
------------------------------
Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)
IT Director City of New Braunfels
------------------------------- MarkShnier__You
So that's the result I expetecd! Are you good now?
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------