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

Formulas Activity

Timezone not Populating in Fillout PDF correctly

I created a form for our rental car contract in Fillout. Everything is populating correctly into airtable except the time. My issue is that I put the "date - time out" in the form eg 12/19 8:00pm. It will populate to airtable as 12/20 3:00am if I hav...

  • 260 Views
  • 1 replies
  • 1 kudos

Resolved! Wanting to show correct quarter and fiscal year

I have this formula for calculating the quarter and the fiscal year of when an invoice should be paid.Program Start date is 7-4-2024 (which is Q3). I want it to be paid the quarter after (so this one would be be paid Q4, FY24) but its showing Q3 - FY...

  • 205 Views
  • 4 replies
  • 0 kudos
TRBS by 5 - Automation Enthusiast
Solved

Resolved! Lookup within formula, how to remove "" ?

Hey there,Thank you for reading me !I have a small issue while using lookup fields within a formula.I've got 3 differents tables : projects, actions, animationsA projet is made of several actions which are also each made of several animationsThe proj...

  • 240 Views
  • 2 replies
  • 0 kudos

Resolved! Update status based on status of linked records

Hello,I have a project table and a milestones table. I want to update the status of my project record to “complete” when all the statuses of the linked milestones are also “complete”i have a roll up field which pulls back the unique array of the mile...

  • 122 Views
  • 3 replies
  • 0 kudos

Resolved! Keep only latest date in a lookup field

I am looking for a way to parse a lookup field (Sprint Start Date) that contains multiple, comma-separated date values, and pull the most recent date into a new field. For example:IF --> Sprint Start Date = 2024-10-12, 2024-12-22THEN --> Formula Fiel...

  • 193 Views
  • 4 replies
  • 0 kudos
SBeau by 5 - Automation Enthusiast
Solved

Resolved! Creating formula that checks the conditions in another table

Hi, I have two tables for which I'd like create a formulaTable 1Feature NameFeature End Date Table 2Sprint NumberSprint Start DateSprint End DateI'd like to create a formula that checks if "Feature End Date" is between "Sprint Start Date" and "Sprint...

  • 143 Views
  • 4 replies
  • 0 kudos

Change in bank balance

HelloI would like to build a base where I have tables with planned income, planned cost and summary table that reflects incomes and costs on monthly basis.My question is, if it is possible to take bank balance as a basis for the calculation and calcu...

K21_0-1734605136192.png
  • 118 Views
  • 2 replies
  • 0 kudos
K21 by 4 - Data Explorer