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.

My if formula isn't working for two different 'if' scenarios...

Topic Labels: Automations Formulas
1828 3
cancel
Showing results for 
Search instead for 
Did you mean: 
imomarsx
4 - Data Explorer
4 - Data Explorer
I'm putting the below formula but it keeps coming up with an error message - any ideas why when each part seems to work independently.
 
IF({Always On/Miniseries} = "Always On" , {Total Budget (USD)}*((13-{Number (from Start Date)})/12) ), IF({Always On/Miniseries} = "Mini Series", {Total Budget (USD)}*{Year 1 (from Mini Series Amort) (from Start Date)})
3 Replies 3
RdMedia_srl
7 - App Architect
7 - App Architect

you can try this

IF({Always On/Miniseries} = "Always On" , {Total Budget (USD)}*((13-{Number (from Start Date)})/12) , {Total Budget (USD)}*{Year 1 (from Mini Series Amort) (from Start Date)})

 


Rodolfo - RdMedia
imomarsx
4 - Data Explorer
4 - Data Explorer

I don't think this will work - as above I need the second part to work differently from the first, i.e. if Mini Series is selected the second line to apply.

Try this:

IF({Always On/Miniseries} = "Always On" , {Total Budget (USD)}*((13-{Number (from Start Date)})/12) ) & 
IF({Always On/Miniseries} = "Mini Series", {Total Budget (USD)}*{Year 1 (from Mini Series Amort) (from Start Date)})

We can't use commas to separate functions and need to use `&`, so I replaced your comma with it; should work fine