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.
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...