Help
Formulas
cancel
Showing results for 
Search instead for 
Did you mean: 

Formulas Activity

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

ashleymf1983_1-1701440972302.png
  • 37 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.

Airtable_admin_0-1701437331894.png
  • 46 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...

  • 31 Views
  • 1 replies
  • 0 kudos
JJJ 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....

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

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

Jill_Pierce_0-1701297979227.png Jill_Pierce_2-1701298061656.png
  • 88 Views
  • 3 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...

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

Vincent3_0-1701271471929.png
  • 51 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 ...

  • 71 Views
  • 2 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...

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

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

Schermopname (17).png
  • 82 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...

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

  • 92 Views
  • 2 replies
  • 0 kudos