Hello all I have these two fields the is the “amount used” and “Status” what I want to do is when the “amount used” is empty I want “pending” when the “amount used” is “0” I want “Void” and when the “amount used” is greater than “0” I want “Used” On ...
Hello. I have a lookup field which lists the age groups that are related to all the linked records. I have a formula field which I’d like to show ‘Senior’ if the lookup field contains Senior, ‘Intermediate’ if it contains Intermediate (but not Senior...
Hi, I’m trying to build an IF statement with an OR in it but I’m not getting the expected result. I have created a simple table for tracking hours worked and calculates overtime. Columns are as follows… Date - is just the date in question. Calculate...
Hi all, Please see the screenshot below - I’d like to display a message in the Is Absent Today column if today’s date is among the dates in Absences. Currently I’m using the following formula but it only works if there’s a single date: IF(DATETIME_DI...
Hi, I’m trying to convert a number to a string. I have a field called ‘Version number’, which is formatted to take two decimals. I want to use this version number in another field as a string because I’m concatenating to generate a document filename....
I’m working on creating a Table that lists Expenses. I’m currently using the following formula to populate a Title for the first column in the table based on columns: Vendor, Frequency, Price, Per Member Price?, Users and Total Due. The “Per Member P...
Hello - I’m quite new to Airtable and trying to prototype out an invoicing application, but I’m running into an snag and could use some guidance. My base: Clients Table (name, id, project lead, etc)Items table - this is a granular list of the items f...
I have a field that includes a date and time. I want to create a new field that give a new date and time that is 24 hours later Please can anyone help?
I have a view with the condition group: When Primary Introducer Contains John Stamos or Secondary Introducer Contains John Stamos or Tertiary Introducer Contains John Stamos Then I have an IF statement determining whether John Stamos is the Primary, ...
I have tables named “Inventory” and “Customer”. What is the best way to create unique price list per inventory record for each customer? I want to have => inventory A is $10 for customer A and $5 for customer B etc
