With my business, I have WAY too many deals that come across that are unique and individual from others. I am in DESPERATE need to find a way to create a formula, (or simply type in a number for that matter) and NOT have it affect ANY OTHER record. J...
Here is the formula I have:
{MLI (Sq. Ft.)}*1.50+{Bluemaxx AC Re-New (Ounces)}103+{Attic Air Seal (Energy Saver)}.32+{H20 Wrap}*75+{Power Perfect Box}*1500+{Solar Fan}*785+{NEST Thermostat}*349
It is working perfectly when all of the fields are fille...
Hello,
I am brand new to Airtable and need help creating a formula. The formula works perfectly in Excel/Numbers, but my knowledge of formulas is proven to be insufficient and I can’t figure out how to do it in Airtable. Maybe it doesn’t have the cap...
Thanks for the clarification. You are a lifesaver! I’m beginning to understand. Yes, I would like the manually entered number (400, 600) to also be multiplied with what is in the {kw} field.
So, to be clear, the formula you’ll be sending (again, than...
Justin_Barrett:
IF(
{Custom Amount},
{Custom Amount},
(200 + ((VALUE(PPW) - 3.75) * 500)) * (VALUE(PPW) >= 3.85) * kW
)
You guys are so incredibly smart! I’m just learning how to do formulas, and pretty much brand new to Airtable....
