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

Formulas Activity

Fill in date cells empty in month

Colleagues top up holidays and travel expenses in Airtable. We would like to account for the empty dates 13 three random days in a given month. Is there any way to automate this?

  • 25 Views
  • 0 replies
  • 0 kudos

Resolved! REPT Formula issue Referencing results from another formula

Hello All,I have looked around the discussion boards for an answer with no luck. I have a formula as follows:REPT("|",{Line Count}) When I use this, it just gives me an #ERROR! as the entry in the field. Entries with a zero in "Line Count" are blank....

  • 55 Views
  • 2 replies
  • 0 kudos

Complex Nested IF AND statement (dates and regions)

I have a complex formula I am trying to write, and unfortunately it says there is an error in my code, but I can't seem to work out what! I am trying to write a custom field that says LIVE, FUTURE or COMPLETED depending on the number of days away an ...

  • 56 Views
  • 2 replies
  • 0 kudos

Resolved! Formula to show min date in DD/MM/YYYY format

Hi There,Seeking some help writing a formula to show the minimum of two date fields in a specified format. I have it working but showing without a forward slash.Formula used so far is =MIN(VALUE(DATETIME_FORMAT({6QIssuedDate},"DD/MM/YYYY")),VALUE(DAT...

  • 71 Views
  • 2 replies
  • 0 kudos

Resolved! Combining two fields with comma when either might be blank

Trying to get 'Full Name', 'Organization' in my primary field. My problem is that sometimes both 'Full Name' and 'Organization' are filled in, and sometimes it's only one or the other. I tried using the following formula, and it worked when one or th...

Airtable Glitch.png
  • 112 Views
  • 7 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...

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

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

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

  • 115 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
  • 112 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...

  • 67 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
  • 61 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 ...

  • 91 Views
  • 2 replies
  • 0 kudos