Easy Formula Help
Moving on to my next application. We keep track of Adobe subscriptions so we can charge the proper departments. I have the table and such setup, I just need help with the Yearly Cost formula. I ha...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendIF([field 1], 1,0)
+IF([field 2], 2,0)
+IF([field 3], 5,0)
Note that in each if statement it ends with a zero because you don't want the result of the effort to be null because that will wreck the total, and make it blank.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Mark,
That's closer to an excel formula than I thought. Did you possibly leave out the "condition"? Should it be more like...
IF([field 1], true, 1,0)
+IF([field 2], true, 2,0)
+IF([field 3], true, 5,0)
Just thinking there isn't a condition to be met in your version.
------------------------------
Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)
IT Director City of New Braunfels
------------------------------Thanks, Mark. I was able to work it out with a little more time. End result, for others possible future reference....
Sum(
If([Field1]=true, 676.54, 0)
+If([Field2]=true, 71.64, 0)
+If([Field3]=true, 286.47,0)
+If([Field4]=true, 297.62, 0)
+If([Field5]=true, 297.62, 0))
------------------------------
Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)
IT Director City of New Braunfels
------------------------------- MarkShnier__You
Your formula will work fine, what the Sum is superfluous.
Also when testing a bully and checkbox field that checkbox field is either true or false inherently so you don't really have to test it against true. For example this is the same thing as I originally wrote just more verbose. I do recognize it's probably easier to read the way you wrote it. (aside form the superfluous SUM( )
If([Field1]=true, 676.54, 0)
+If([Field2]=true, 71.64, 0)
+If([Field3]=true, 286.47,0)
+If([Field4]=true, 297.62, 0)
+If([Field5]=true, 297.62, 0)
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------Ah, that makes sense. It's "smarter" than me, if its a checkbox. I get it now. The more verbose option would really work if I was doing this with a multiple choice field. Right?
------------------------------
Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)
IT Director City of New Braunfels
------------------------------
