Formulas | Airtable Community

Resolved! Attachment Field

I need to evaluate whether or not an attachment field is blank with an IF statement. Variations of double quotes and the BLANK() function don't do the trick. Any ideas?

62 Views
2 replies
0 kudos

Formula to Identify Time Ranges

Hello!I have a formula field that calculates the number of hours between two date fields. I want to then parse this into categories based on the duration:A = hours ae greater than 96B = hours are greater than 24, but less than 96C = all remaining pos...

48 Views
1 replies
0 kudos

Monthly Amount formula in a budget with various frequencies of amounts

I am creating a budget and have amounts incoming at various frequencies. I want to create a field that calculates the monthly amount based on a formula. This is the formula I have got but I get an Invalid Formula error message:IF({Frequency} = "Daily...

49 Views
1 replies
0 kudos

Automation to notify status changes based on previous status

I want to know when an approved campaign goes back in to revisions so that I can review it again. I have multiple other reasons to want to know when a campaign status changes and what the previous status was; e.g., trigger subtasks for team members, ...

68 Views
1 replies
0 kudos

Autofill a "link to" field

Hi all, apologies if this question has been asked and answered already. [EDIT: attached a screenshot since the embedding images don't seem to work.]I am creating a table of contacts for relationship management. For each person, I have the fields "Int...

93 Views
1 replies
0 kudos

Formula to find date of specific day prior to designated date.

I am trying to figure out the formula to populate the date of a specific day in relation to a designated date.Below are some examples of what I mean.I have a date field titled EVENT DATE. I want the column titled PAYMENT DUE to populate the date of f...

63 Views
1 replies
0 kudos

Using Airtable to settle utilities with tenants

Hi Guys, I'd like to use Airtable to build a utility settlement tool with the tenants. My tenants pay an advance for utility every 6 months; after 6 months (this period might differ), I record the meter reading and fixed and variable utility prices (...

70 Views
1 replies
0 kudos

Resolved! Duration TEXT to correct formating

can you please help me convert this to the proper duration format? OR maybe into Seconds.I have the formula below:VALUE(LEFT(SUBSTITUTE({Fulfillment Time}, ' minutes and ', ':'), FIND(' seconds', SUBSTITUTE({Fulfillment Time}, ' minutes and ', ':')) ...

115 Views
4 replies
0 kudos

Count occurence of each unique in a Rollup

Hi,Let's say I have a People table with Name A, Name B, Name C.Another Table "Sports", which links Name A with Football, Name A with Football (again), Name A with Basketball, Name B with Basketball, Name B with Basketball, etc.In the People table I w...

95 Views
2 replies
0 kudos

Score Analyzer Loan App

8653906699

91 Views
0 replies
0 kudos