The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
I have various contracts and various contractor invoices that I need to review, and I want two formula fields to confirm whether the billing periods covered by each invoice - and the invoiced amount - are "valid". My table is pulling in the contract ...
I am trying to create a table that calculates equipment depreciation by straight line, sum of years, and double-declining, because we have a number of different equipment types that depreciate in very different ways, but want to monitor all of them i...
I have one table of people, and another with records of their visits. In the people table, I am trying to add a field that will tell me the date of the earliest visit… after 9/30/2016.
I tried adding a formula field in the visits table to return the ...
I am trying to add a formula field that replaces all spaces in a long text field with “+”, and all paragraph breaks with “\n”. How do I designate a paragraph break in a formula?
SUBSTITUTE(SUBSTITUTE({Event Details},’ ‘,’+’),< p >,’\n’) won’t even s...
Oh I forgot to include that I ultimately also need to see for each contract how many months they've invoiced for and the average amount invoiced per month. I could do some kind of roll-up getting the earliest date from "Billing Period Start" then a s...
Thanks for your help! I ended up settling for one formula just showing me if the date is between the contract start and end dates:IF({Billing Period End}<={PoP End},IF({Billing Period Start}>={PoP Start},"Valid","Outside PoP"),"Outside PoP") Then I j...
I absolutely despise the new layout. I use Airtable for personal use and for work, and share my screen half the day in meetings. I do not need my coworker seeing my other bases up at the top when I open another tab of Airtable... Worst "upgrade" ever...
Update! Airtable support got back to me in record time. Google Translate is getting too big for its breeches or whatever the expression is. Change the setting to Never Translate This Site.
Ahh me too!! What is happening? I have never seen this before. Did anyone ever help you? I have a field for first names, so when I type “Lance” and it shows me “Spear” this is not cool. When I open the record, it looks correct. It’s just changing it ...