Hi!
I created a formula to pull item, rate, and event time from Airtable records. The formulas below are to compute the qty and total for each item according to the event time. It is computing properly for all types of items we have except for the labor types. When I do the formulas for the labor themselves, they work, but in the nested formula, they’re just defaulting to 1 qty and the base rate.
Is there an error in the formula?
Welcome to the Make community!
To allow others to assist you with your scenario, please provide the following:
Please export the scenario blueprint file to allow others to view the mapped variables in the module fields. At the bottom of the scenario editor, you can click on the three dots to find the Export Blueprint menu item.
By providing these details, it will allow others to assist you better.
Attached is the scenario blueprint. The formulas are in the Microsoft Word Template module.
MAKE eSignature blueprint.json (217.8 KB)
Attached is the scenario blueprint. The formulas are in the Microsoft Word Template module.
MAKE eSignature blueprint.json (217.8 KB)
Yes, I was testing to see if either one was the issue but both formulas return the same calculation.
Does anyone know or has had this experience? Does Make have a nested IF statement limit?
