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

Formulas Activity

Determine if a record falls between a date range?

I'm struggling to figure out a good way to determine if a projects start and end date span any part of a specific year where start and end dates could span multiple years.So for example, I have records with the following columns for projects:Project ...

  • 7 Views
  • 0 replies
  • 0 kudos

Help! Finding last occurrence of specific string

I have a base with records that consist of the URLs of several images inside my site's midia folder. They look something like:https://mysite.com/news/april/banner1.pnghttps://mysite.com/news/may/banner2.pnghttps://mysite.com/news/april/etc/week2/file...

  • 17 Views
  • 0 replies
  • 0 kudos

Formula If and dateadd

 Hello airtable community, I have this following formula but dateadd does not display the operation in the result thank you for your feedbackFranck IF({Date début package} != '', {Date début package},IF({Date début expl 23} != '', {Date début expl 23...

  • 56 Views
  • 3 replies
  • 0 kudos

Rollup fields, formulas, and nuances driving me nuts

Dear community of people so much smarter than me!I am using Airtable to build a film budget that has a number of fields and formulas that are causing me headaches. Table 1) Budget top sheet (two rollup fields: budget & actuals)Table 2) Budget (above ...

  • 194 Views
  • 1 replies
  • 0 kudos

Workday function showing weekends

I am trying to have a due date automatically calculated, but don't want weekends or holidays included. I am using the WORKDAY function, but still getting weekends. Workback from is the date to begin working on each task and Workback is the number of ...

  • 52 Views
  • 2 replies
  • 0 kudos

Resolved! I need a formula for 2 decimal digits mixed with text

I'm new here so I do not know that many formula. I imported my tables from excel and I have it generate name of the product with product name + weight. However, I want the numbers that are generated in 2 digits format. And here is my current formula ...

Screenshot 2024-04-25 103621.png
  • 175 Views
  • 13 replies
  • 0 kudos

Resolved! Nested formula only partially working

Hello,I'm trying to create a mapping using IF and OR statement, in order to map a set of values for the 'Status' field to this new formula field.  This formula doesn't cause an errors, but it only partially works.  Does anyone know why this doesn't w...

  • 799 Views
  • 4 replies
  • 0 kudos

Resolved! Formula within automation

Hi - I am trying to update a forecast in case the field hasn't been updated for over a month. The idea is that if there are no updates, the forecast would lower by 10%. It all looks great, until I have to "Update record", I pull the record ID (dynami...

  • 79 Views
  • 2 replies
  • 0 kudos

Resolved! IF Statement blues....

I've read through several help topics and I am still having issues, hoping someone can help me. I have a field that is counting the days between the due date and todays date. I need to use these numbers to create a formula to provide an aging report....

younger3_1-1713970576050.png
  • 131 Views
  • 5 replies
  • 0 kudos