Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

If Statement Question (Money amount for different job types)

Topic Labels: Formulas
378 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Could someone tell me what I’m doing wrong? For some reason this formula is able to input the money amount for job 1, 2, 3, and 5 but it shows up blank for job 4. What’s going on?

IF(
{Job Type} = ‘Job 1’,
“$ Amount”,
IF(
{Job Type} = ‘Job 2’,
“$$ Amount”,
IF(
{Job Type} = ‘Job 3’,
“$$$ Amount”,
IF(
{Job Type} = ‘Job 4’,
“$$$$ Amount”,
IF(
{Job Type} = ‘Job 5’,
“$$$$$ Amount”
)))))

1 Reply 1

it’s been resolved :stuck_out_tongue: