4 - Data Explorer
since ‎Dec 16, 2020
‎Nov 29, 2022

## User Statistics

• 9 Posts
• 0 Solutions
• 0 Kudos given

## Formula formatting? conditional IF

if (Check if Not Converted)=1, {Exchange}*{Total} cant seem to get this to work any help appreciated ty

## Your result type is not a number or a date. Formatting options are currently only available if your result type is a number or a date

I have calculations going beyond the hundredth decimal and would like to be able to format the formula into currency to the .00: IF({Unit} = “g”, {Price}/{Qty}*100 & “/100g”, IF({Unit} = “mL”, {Price}/{Qty}*100 & “/100mL”, IF({Unit} = “kg”, {Price}/{...

## Quick formula help?

IF({Unit Type} = “Bins”, {Units Complete}/32, “Feet", {Units Complete}/53) Proper formatting so it works?

## IF {Date:Time} matches {Date} Then {X}

I’m trying to come up with a formula where if {Date Time} matches {Date}, then {abc} is displayed. Pls advise thank u

## Emailing multiple records on Mobile App

I’m struggling to find a way to do this and not even sure if it’s possible with Airtable app and can’t seem to replicate the “right-click” on Desktop Version on Safari (iPhone) either. Any ideas?