The Community will be undergoing maintenance from Friday February 21 - Friday, February 29 and will be "read only" during this time. To learn more, check out our Announcements blog post.
Let’s say that I have to track a team tournament and the team has to register. Each team has 10 people and each person’s information has to be inputed e.g. name, phone, email, team name.
Is there a way to automatically create 10 rows for a team and ...
For the Single Select, is there any way to control what values get displayed?
Say if someone selects A in field 1, then field 2 will display A1, A2 in the dropdown. If B is selected in field1, then field 2 display B1, B2.
If there is no way to do th...
I have two types of contacts in our CRM. I would like to be able to show certain fields for one type and show other fields for the other type.
Is this possible to have this behavior?
Thanks.
Try & instead of +
Airtable - Support
Formula field reference
For an overview of formula fields, please refer to the Guide to Formula, Lookup, Count, and Rollup fields.
Formulas may involve functions, numeric operations,...
Here is a version using Nested If statement. The 2 in DATEADD is for a grace period.
IF(T({Payment Received}) = "Paid",
"Paid",
IF(T({Payment Received}) = BLANK(),
IF(OR(T({Invoice Date}) = BLANK(), DATEADD({Invoice Date}, 2, 'days')>NOW(...
Here is a formula you can use. Update the column name to match yours.
IF(OR(T({Stop Time}) = blank(), T({Start Time}) = blank()),
"",
CONCATENATE(
DATETIME_DIFF({Stop Time}, {Start Time}, 'hours'),
":",
MOD((ROUND((DATETIM...