Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Jul 25, 2022 06:54 AM
I’m trying to link multiple fields together and cap the number depending on another field’s selection.
For example:
Currently I have this formula working as intended in the a field:
{X field} / WORKDAY_DIFF({Y Date}, {Z DATE})
I want to add a quantifier on top of that will determine the number it puts out.
So, if field A=B, cap the number at 2
If field A=C, cap the number at 1.
Jul 25, 2022 11:50 AM
Try the following:
MIN(
IF({Field A} = "B", 2, 1),
({X field} / WORKDAY_DIFF({Y Date}, {Z DATE}))
)
That will take your original calculation and insert it if its less than either 1 or 2 (depending on Field A}'s value). If it its higher than that number, your cap number will be shown instead.