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
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
Qrew Legend
Qrew LegendCan 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
------------------------------Sorry man, I must be particularly dense here. I am not trying to count the number of instances where we have a data entry. I am trying to combine Fire and EMS calls in a given month and FY. I would like to do this without having the user do a calculation or make another entry. As is, they make two records. One for each month. One with Call Type "Fire". One with Call Type "EMS". I would like to add those two numbers to be on the chart beside them. Such as this...
------------------------------
Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)
IT Director City of New Braunfels
------------------------------
