Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

If Statement Question (Money amount for different job types)

Topic Labels: Formulas
1036 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Producer
4 - Data Explorer
4 - Data Explorer

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
Producer
4 - Data Explorer
4 - Data Explorer

it’s been resolved :stuck_out_tongue: