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

Forum Posts

Resolved! Date Formula Subtracting A day

Hi,Am using a formula I've used in bases before, but it's behaving strangely.  It's subtracting a day off of the returned value.  I have two fields with dates.  Only one of the two will ever have a date in it.  I want the formula to grab the date fro...

Eric_Bryant1 by 5 - Automation Enthusiast
Solved
  • 752 Views
  • 2 replies
  • 1 kudos

Resolved! Issues with inaccuracies in my math

Howdy yall, I am trying to do a simple math setup for a client. calls per hour, demos per hour, calls per demo... The issue I am running into is the math seems to be coming back wrong. I have tried a few different ways and still having issues. Here y...

Screen Shot 2023-01-25 at 12.42.42 PM.png

Student Interactive Leaderboard

Hi all, I am looking to create an interactive leaderboard, where my students fill out a form which relays the results back into a board. I have a rough idea of how to do this, but was wondering if anyone has attempted this before or any leaderboard t...

CX2023 by 4 - Data Explorer
  • 680 Views
  • 0 replies
  • 0 kudos

Resolved! Handling "Infinity" errors and IF statement formatting

Hi,  I have an issue when using the formula fields in AirTable when using an IF statement.Context: I need the fields to be format as a percentage, or blank if there's an error/infinity.Here is the formula that I want to use in its simplified form, an...

Screen Shot 2023-01-31 at 12.48.43 PM.png Screen Shot 2023-01-31 at 12.50.33 PM.png Screen Shot 2023-01-31 at 12.53.09 PM.png Screen Shot 2023-01-31 at 12.54.50 PM.png
Dennis_Yu by 6 - Interface Innovator
Solved
  • 1574 Views
  • 3 replies
  • 1 kudos

Resolved! Is it possible to use a image saved in bases URL in page designer?

In my base I got some images saved which I want to use in page designer.I believe I used to be able to use the Image URL in the page designers Image element. It seems still to work for about 24 hours and then the URL becomes invalid (which believe ha...

Formula to calculate debits and credits for personal finance

Hey guys, I've got a new challenge in my quest to create a base for tracking personal finances.  A quick review:TablesCategories (I call them buckets)TransactionsDesignationsTransactions are either entered manually or bulk imported via csv from my ba...

Screen Shot 2023-01-24 at 8.07.18 PM.png

Verify Facebook/Google Pixel Placement on Webpages

I have to regularly place Facebook/Google pixels on webpages and was wondering if there's a way to track via a formula, button, or script whether the pixel on that webpage is working or not. I have a field in the table for the URL the pixel would be ...

Rollup Fields with Dates & Average

Hi all,I am trying to extract the mean/average of a set of dates through roll-ups. I am able to calculate the min or max date through the use of MIN(values) or MAX(values), but AVERAGE(values) returns NaN.Any suggestions? (thanks in advance!) 

Raphael1 by 4 - Data Explorer
  • 608 Views
  • 1 replies
  • 0 kudos