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

Formulas Activity

Really struggling with unique count of a rollup field.

For context, monitoring product listings on Amazon.I have 4 tables:Brands, with a lookup field to ASINs, from CatalogCatalog (containing ASINs), with a lookup field to OffersOffers, showing every offer on each ASIN, where each offer has a Seller ID, ...

  • 485 Views
  • 1 replies
  • 0 kudos

Resolved! Combining cells for repeated content/values

Hello community,I'm building some kind of table where it has repeated content in the rows that I would love to have them combined, similar to a merge cell in Excel or Google Spreadsheets.Is it there a formula or a scripting that can help me have some...

combined.png
  • 149 Views
  • 3 replies
  • 0 kudos

Resolved! Finding Number of Days between a date range

Hi,I have a formula that currently works 90% of the time which finds the number of days between a date range for a given month. The issue is, when the end date, ends in the month I am looking for, example below Oct the formula is correct (row 1, 3 an...

Ann_Yeom_1-1730138629864.png
  • 148 Views
  • 3 replies
  • 0 kudos

Get comment info

Hello,I need your help with comments. Users of my interface can easily enter comments on a records. The problem is that I have other tools linked to Airtable, and I would like to find a way to put the date of the last comment or just the comment coun...

  • 143 Views
  • 3 replies
  • 0 kudos

Simple Calc Function Won't Work, Please Help!

Hi All,I'm attempting to calculate a simple calculation from fields that already exist in a given table: ({gross_expected_revenue_per_qty_sold} * ({your_split} / 100) * {qty_sold}) - {cogs} - ({printing_costs} * {qty_sold})I thought I was going crazy...

  • 181 Views
  • 3 replies
  • 0 kudos

Comparing a date field to a date I input in a formula?

Hi everyone,I have been struggling with comparing a date of when a record has been created to a date I am manually inputing into the formula. So basically I am trying to use the IS_AFTER function but have tried so many things and just everything is e...

Screenshot 2024-10-25 at 12.24.03 PM.png Screenshot 2024-10-25 at 3.01.51 PM.png
  • 206 Views
  • 4 replies
  • 0 kudos

Datetime_Format WRONG DATE after 12:00

Hello, I need help structuring my datetime_format as it has been showing inaccurate days.What I want is to have ~ Live Event ~ On-Air Start date(MMDDYY) and my formula is below:However, with this formula, it is producing a date that is the following ...

NicoleFleit_0-1729797165404.png NicoleFleit_1-1729797419695.png
  • 117 Views
  • 1 replies
  • 0 kudos