Hi, I am having trouble writing a formula for the following. I would be most grateful for help! I have a calendar field for Due Date. I’d like to make a field that says “overdue” when the Due Date has passed, “today” when the Due Date is today, “comi...
I have a book database and I am splitting the Author name into Author First and Author Last columns. The problem I run into is certain books are authored by a company. I don’t want to split the company name up. Is there a way to identify an company n...
I have lots of dates that are setup as numbers in my excel sheet that I am bringing into airtable. I need to change the formatting of the dates while leaving them as numbers in the original column. Example. 20170112 YYYYDDMM I need it converted to 12...
I have an employee time log database where each employee signs in with a timestamp date field (they can adjust it if they need to). Then they log out, and an additional field calculates their hours: DATETIME_DIFF({Time out}, {Time in}, ‘minutes’)/60 ...
I want to convert a list of words separated by semicolons in one column to a list of words separated my commas in another column. Any Ideas on how to do this in Airtable?
Can multiple formulas be assigned to a field. I have a filed that determines the days between Estimated completion and Date started, Wanted to have the Field change color if late, if not late, or have a label stating “No assigned Date” if no dates we...
Hi I am new to Airtables and trying to create a formula that uses data from another table, is this possible?
Hello, I have a table of courses linked to a table of course runs. The course run table has many records connected to one course. The course runs table has multiple course run dates linked to a single course. I would like to calculate the next upcomi...
I’m wondering if there is (or could be) a way to change a formula for a particular cell or row? For example: I use airtable to track gigs for artists I represent. Typically, we take x% for every gig. In certain special cases, we may take y%. Is there...
OK, so, strictly speaking not a bug, but certainly an infelicity. :slightly_smiling_face: Maybe someone can step on it next time something else needs fixing in DATETIME_DIFF… For background, see this post in the Support forum. Specifying 'day ' or ...
