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

Forum Posts

Count Items Based on Color-Code Option in Multi-Select

Hello!I have a list of names under a multi-select. Everyone in Blue is a FT staff member, everyone in yellow is a contracted worker. I want a count field (or formula field) that will automatically count all the Blue multiple select to give me the tot...

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
  • 62 Views
  • 2 replies
  • 0 kudos

Resolved! 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
Solved
  • 71 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
  • 168 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
  • 172 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
  • 108 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
  • 162 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
  • 222 Views
  • 3 replies
  • 1 kudos