Don’t you hate it when you can do something on paper easily, but are struggling to make it work digitally!?! Wondering if someone can point me in the right direction.
Outcome:
I want to create a new Service Record (let’s call that record B), based on...
Hi friends,
I’m hoping someone can help troubleshoot why a conditional rollup is returning a zero “0” value.
Table 1 has a list of vehicles.
Table 2 records all certification renewals. There’s about a dozen different certifications required per vehic...
Elias, you’re a star. Thank you. Spot on.
The FALSE statement (as a text option, “NA”) was throwing the formatting.
It now works perfectly and reads as:
IF({Certifications}="SLP",{Date Next Expiry},BLANK())
Thank you.
Hi Elias,
Below is a screenshot of the Formula. Airtable isn’t seeing it as a date (which might be the issue). The source field {Date Next Expiry] is simply a Date field in European time formatting.
You appear to have one too many IF statements (the double “NA” at the end is confusing). Try moving your Blank first and reducing it to three arguments (which will give you your four responses).
P.S. Love the emojis.
IF(
{Hose Inspection Expiry Date}...
