Caolan - profile

Caolan · Nov 14, 2019

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...

Caolan · Oct 30, 2019

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...

Caolan · Oct 30, 2019

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.

Caolan · Oct 30, 2019

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.

Caolan · Oct 16, 2019

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}...

User Statistics

User Activity

Conditional Forecasting and Scheduling

Conditional Rollup Max Date

Re: Conditional Rollup Max Date

Re: Conditional Rollup Max Date

Re: Remove #Error and return N/A when a field is blank