Formulas
cancel
Showing results for
Did you mean:

Formulas Activity

Populate "Urgent" when {Due Date} is within 7 days of TODAY and {Date Filed} is EMPTY

Hi, I am trying to populate in a cell, "Urgent" when a project is coming up on its {Due Date} within 7 days of today AND the cell that has my completed date, {Date Filed} is Empty. If {Date Filed} is Not Empty, i'd like it to populate "Completed". If...

• 13 Views
• 0 replies
• 0 kudos

Resolved!If Sale Price=BLANK do X, If Sale Price≠BLANK do Y - Airtable considers "\$0.00" = BLANK

I have a formula that I'm attempting to show "Sold" if tickets to an event have been sold, but if the tickets have not been sold, to display the number of days until the event. I already have another formula that will give me the number of days until...

• 9 Views
• 1 replies
• 0 kudos

Count unique values in a column by another column

Hello All,This is my first post here & I am an Airtable newbie.I am trying to get my table to show the number of unique values for 1 column based on another column.Here is an example of my data:I want to insert a column that counts the number of uniq...

• 18 Views
• 1 replies
• 0 kudos

Fill in cell as '1' if the formula gives 'NaN'.

The cell gives an error (NaN) when the linked table does not contain any linked records. I want to create a formula that will fill-in the cell as '1' if the 'average (values)' is not possible. Thank you.

• 24 Views
• 1 replies
• 0 kudos

Problem creating a URL formula using any field that contain more than one word in a cell

I am trying to create a URL to search Google Shopping for a specific combination of (Brand, & Product Title), however i am noticing that if either the Brand or Title has more than one word, the URL does not form correctly:Ideally I would use the Goog...

• 35 Views
• 1 replies
• 0 kudos

Remove date/time from field

I just started using Airtable and I'm trying to remove the date/time from a column or create a new column that has the date/time removed with just the remaining text. The column is linked to another airtable and it is using the primary field, so I do...

• 21 Views
• 1 replies
• 0 kudos
by 4 - Data Explorer

Creating a shared link to just attachment images

Hi allI'm trying to make a URL to link directly to show just images in an attachment field.I've created a shared view, and am happy making a formula which replaces the record ID to the correct record but I can't get the attachment ID programatically....

• 37 Views
• 1 replies
• 0 kudos

Resolved!IF formula to return # of hours only if month falls within a date range

Hi-  I'm a pretty new Airtable user, and have been trying to find solutions via the community posts, but haven't seen anything exactly addressing what I'm attempting to do.I am trying to populate a field with a number of hours to be worked, only if t...

• 51 Views
• 2 replies
• 0 kudos

Resolved!Concatenate and summarize each rollup value

Hi all, I have a two-table base. The first table/screenshot below is for survey responses; each record is an individual survey response. The second table/screenshot is where the responses roll up for each survey. Is there a way within the rollup file...

• 60 Views
• 3 replies
• 0 kudos

How to Lookup and retern spacific record from Diff Table to the current Table ?

Hello , thanks for taking time for giving a hand  on this Table 1 ( Currency ) for Monthly Foreign Currency Ex RatesUSD Nov 2023SAR Nov 2023EGY Nov 2023 Table 2 ( Budget Line ) which contain the monthly budget line in different Monther Table 2 will h...

• 51 Views
• 1 replies
• 0 kudos

Split start and end dates which can be formatted differently

Hi there!I am getting start and end date as a text in one field.BUT format could be different in each record (mm/dd/yyyy OR yyyy-mm-dd)I want to find a formula to split A field (which could be formatted in two ways) into start (B) and end (C) datesTi...

• 44 Views
• 0 replies
• 0 kudos

Utlization summary looks ''across'' multiple weeks

The Utilization Summary works differnt than I expected, and I can't figure out why.I think this image summarizes my question: In short:I have 5 working days (40 hours) per employee as ''Available hours''And my tasks are split into working days, where...

• 43 Views
• 0 replies
• 0 kudos

Round a time up to nearest 30 seconds

HiI have a field called {Total Duration} where the user enters the length of a video in h:mm:ss format. This formula is going to be used to calculate the costs of video editing. We charge in 30 seconds units. 1-30 seconds is charged as one unit, but ...

• 56 Views
• 2 replies
• 0 kudos

Formula creating a total for multiplying multiple columns by fixed cost

Hello! I figured this out before and accidentally cleared it a while back without noticing. For context, I am trying to find the total cost associated with ordering additional curriculum books. In the form submitted, customers can select additional b...

• 59 Views
• 1 replies
• 0 kudos

Remove white spaces at the beginning of all fields

Hello,I would like to not have a space at the beginning of each entriesI think I have to use Trim but My formulas is long and I do not know how to make sure each line and trimmed.Right now with this formulas each lines as a white space at the beginni...

• 55 Views
• 1 replies
• 0 kudos

Need help on IF formula

Hi,I want to create an IF formula but the result I get is not what I expectedHere is the formula: IF({Date effective de fin du cadrage (from Date effective de fin du cadrage)}<{Date estimée de fin du cadrage (from Date estimée de fin du cadrage)},"In...

• 97 Views
• 3 replies
• 0 kudos

Resolved!Time change after CONCATENATE formula

Hi there.In a field, I have used the formula below: DATETIME_FORMAT({Datum gesprek}, 'DD-MM-YYYY HH:MM')&", "&{Traject begeleider} Weirdly, the outcome makes the time change by a few minutes. I can't figure out why. Setting timezone, or changing othe...

• 76 Views
• 2 replies
• 0 kudos

duplicating a recored and its linked filed.

I’m trying to use automation to copy a record and create duplicates of all the linked records in the original record. Here’s what I’m trying to do:Create a new record and update it with all the fields.Search the other table for all the records that a...

• 55 Views
• 1 replies
• 0 kudos

Resolved!Finding out the maximum number of accounts

I am working with a subscription table and every row is an entry every time a customer subscribed to an account (It is possible for a customer to have more than 1 account). I have a field for Start Date and End Date, and I want to know the maximum ac...

• 89 Views
• 2 replies
• 0 kudos

Suggestion: Add "Formula Script" field type

How about creating a new field type ("Formula Script" or such), where Script (or at least some subscript) can be used for a field formula?

• 192 Views
• 0 replies
• 0 kudos