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 have a bunch of checkbox that can be checked to indicate which subscriptions a user has. I get a new yearly cost each year that I can use to update the formula. So my formula in plain terms, I just don't know formula syntax here yet.
If field 1 is checked/true, add $1. If false, add $0.
If field 2 is checked/true, add $2.If false, add $0
and so on.
------------------------------
Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)
IT Director City of New Braunfels
------------------------------
