I have a table called "companies" that is linked to another table called "deals" where 1 company can have many deals. On the companies table, I have a roll up called "latest deal", that takes the max deal start date from the deals that the company i...
I have a table called 'jira tickets' with a single select column called 'status' with options like new, in progress, done, closed etc.The options in the single select are ordered appropriately within the field definition and so if I group by the stat...
I have this working formula to return 'Reaction Hours'...ROUND(DATETIME_DIFF({Reacted Date & Time},{Request Date & Time},'minutes')/60,2) If the request and reaction times are equal, 0.00 will be returned (correctly). But then I embed it in an IF st...
I have a base that has a number of tables representing incoming work from different sources (e.g. a jira tickets table, a slack messages table, a spreadsheet process table, a email table). And I want to combine them into a single 'team workload' tab...
I have a table called contracts and I have 200 google sheet spreadsheets representing each contract. I can import/sync to Airtable from a Google sheet but I only want 1 row per contract (200 rows total), and I want the fields to map to specific spre...
that worked great thanks! I thought I had to specify an else condition in these if statements but I guess not. No idea why the else condition was triggered though since both the values of the AND statement were present. Either way you fixed the bu...
thanks for taking the time to demonstrate that so clearly - I can see how it would work, but the issue is that I only have 1 project, and so creating a brand new table feels really over-engineered and potentially confusing for users wondering why tha...
Hi @Vivid-Squid, No there’s no separate projects table - just a companies table with a projectComplete flag. Even if I just plot a chart in the interface using the projectComplete flag, for some reason something like a donut chart will only display ...
