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

Forum Posts

Need help regarding advanced formula usage

Hello there,I am trying to create a formula that calculates the total cost of items based on their quantity and unit price; while also factoring in a discount percentage if applicable. I have tried using nested IF statements; but I am running into so...

elija6266 by 4 - Data Explorer
  • 22 Views
  • 1 replies
  • 0 kudos

How can i get info from a Linked Record through a Formula

I have 4 Tables (Payments, Receivables, CostCenters, Extract)The Payments and Receivables records are linked to CostCenters records.The Extract records are linked to Payments ou Receivables records ("If it's a receipt, it will be associated with an a...

Guics by 4 - Data Explorer
  • 57 Views
  • 1 replies
  • 0 kudos

Auto-allocate 100% across multiple projects

Hey all! I am trying to set up a form that is being sent out to about 200 people for the purpose of tracking time allocation for employees. To do so, the employees will fill out a form at the end of the week, selecting the projects they worked on thr...

Anonymous by Not applicable
  • 162 Views
  • 1 replies
  • 0 kudos

Date Formulas

Hi there,Wondering if anyone could help me with a couple of formulas.I have an existing date field (DD-MMM-YY) and I want to create deadlines from this field as follows:1.  23rd day of the 9th month after this date; example - where source field is 31...

Count with a dynamic condition on a date set in a field

Hello everyone,I have the following problem, which I haven't been able to solve for weeks. Basically, I want to do a Count with a dynamic condition on a date, which is not possible in the Count field settings.I have three linked tables:1 table A "Con...

ErwanLP by 4 - Data Explorer
  • 158 Views
  • 5 replies
  • 0 kudos

Viewing financials over time

Hi,I'm using AirTable to track potential sales opportunities and would like to visualise on a chart the revenue per month.  This is similar to the Gantt chart view but instead would show the size of revenue rather than simply a project.For example, i...

DanR by 4 - Data Explorer
  • 93 Views
  • 3 replies
  • 0 kudos

Resolved! Complicated lookup field's Type causes formula to fail

I have two tables Experiments and Readings.Each experiment is linked to two or more reading records. Each reading has a DateTime field, and some readings such as pH and temperature. The pH and temperature readings are number fields.I want to use the ...

jethroc by 5 - Automation Enthusiast
Solved
  • 136 Views
  • 6 replies
  • 2 kudos

Resolved! Restringir fecha before today

Hi, I am doing a form for a remiders request, and I need that the filed "fecha de envio" the person is requesting the reminder have not the option to select a day before Today (current day).

DaniMadrid24 by 5 - Automation Enthusiast
Solved
  • 214 Views
  • 3 replies
  • 1 kudos

Record ID for a form

Hola necesito generar in ID de solicitud para mi form que sea facil de buscar o indentificar

DaniMadrid24 by 5 - Automation Enthusiast
  • 122 Views
  • 2 replies
  • 0 kudos