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

Formulas Activity

Remove root domain from URL

I want to remove the root domain from all of my URLs after a specific character. I want to remove the root of our URL (https://cotoncolorscompanywholesale.com) AND I want to remove /pages/ so that I am only left with the actual page name. Take these ...

  • 12 Views
  • 0 replies
  • 0 kudos

Roll-up formula based on dynamic conditions / selective roll-up

Hello everyone!I have two tables:Table 1, where records correspond to products,Table 2, where records correspond to sales of products.I'm trying to create a single roll-up field in Table 1, so that for each product record, it gives me the sum of all ...

  • 27 Views
  • 0 replies
  • 0 kudos

creating a link to form with prefill from another table

Hi,I have two tables I work with:1. table of employees,2. Table of events3. table of enrollment to each event.I want people to enroll to events each time an event is created.I created an enrollment form in the enrollment table to insert the data ther...

  • 43 Views
  • 1 replies
  • 0 kudos

Formula to update status based on checkbox?

Hello!I am trying to set up a formula to when a checkbox in the field "Invoiced?" is checked, the "Status" field is then changed to "Invoiced". I am setting this up so that Zapier can (hopefully) check a box if a record is still there and override an...

  • 84 Views
  • 1 replies
  • 0 kudos

Select Filtering

I've got a handful of companies that had meetings taking place on various dates.  I want to filter out those companies who did not meet on both 07/17/2023 and 12/05/2023.  For example, if Company A met only on 07/17/2023, it would not be shown.  If C...

  • 74 Views
  • 0 replies
  • 0 kudos

Randomize meetings

Hi everyone! I'm trying to tackle an issue that I'm not sure I can solve with Airtable, but hoping to alongside Zapier integrations. I want to randomize monthly meetings across our staff, volunteers, and board. Not everyone is willing to use Slack, w...

  • 74 Views
  • 0 replies
  • 0 kudos

Help creating a formula for Project Status

Hi there,We are using AT as a project management tool and I am trying to create a field that indicates Project Status. The field would live on the Projects board and default to "Submitted", when we receive a request. We have a separate board for Task...

  • 91 Views
  • 0 replies
  • 0 kudos

vacation day formula - help

I am having trouble with my vacation day calculation when an employee is only taking one day off. I have a formula to count the days requested and they always show up as negative which is what I want to subtract from their approved days, but when the...

  • 87 Views
  • 1 replies
  • 0 kudos

formula to calculate events dated last week

Hi everyone,I'm trying to create a formula field to calculate last week.I have a view that shows me the events that refer to last week, I added a formula field to calculate all the events that have the "Date" field dated to last week, but it doesn't ...

  • 66 Views
  • 1 replies
  • 0 kudos

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?

  • 47 Views
  • 1 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....

  • 86 Views
  • 2 replies
  • 0 kudos

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

  • 107 Views
  • 3 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...

  • 106 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
  • 170 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
  • 81 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
  • 107 Views
  • 3 replies
  • 0 kudos