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 FORMULA HELP

Solved
Jump to Solution
1431 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Scott_Gardner1
7 - App Architect
7 - App Architect

Question, I need a filed called START to pull from different fields that have dates:

For some reason only the Game Development date is being pulled, any idea's?

 

SWITCH({Stage},
IF({Stage}='READY FOR GAME DEVELOPMENT',DATEADD({GAME DEVELOPMENT},'','DAYS',
IF({Stage}='READY FOR CREATIVE DESIGN',DATEADD({CREATIVE DESIGN},'','DAYS',
IF({Stage}='READY FOR PRODUCTION',DATEADD({PRODUCTION},'','DAYS'
)))))))
1 Solution

Accepted Solutions
Sho
11 - Venus
11 - Venus

You are probably mistaken.
The SWITCH formula goes like this.

SWITCH({Stage},
'READY FOR GAME DEVELOPMENT', DATEADD({Date},1,'DAYS'),
'READY FOR CREATIVE DESIGN',DATEADD({Date},2,'DAYS'),
'READY FOR PRODUCTION',DATEADD({Date},3,'DAYS')
)

See Solution in Thread

3 Replies 3
Sho
11 - Venus
11 - Venus

You are probably mistaken.
The SWITCH formula goes like this.

SWITCH({Stage},
'READY FOR GAME DEVELOPMENT', DATEADD({Date},1,'DAYS'),
'READY FOR CREATIVE DESIGN',DATEADD({Date},2,'DAYS'),
'READY FOR PRODUCTION',DATEADD({Date},3,'DAYS')
)
Scott_Gardner1
7 - App Architect
7 - App Architect

Thank you! I have one more if you don't mind 🙂

I need to add days when not blank to the DEV WEIGHT formula field from a field called ADD TIME TO DEV, a number field. So if I add 14 days in this ADD TIME TO DEV field, the DEV WEIGHT date formula field would add the 14 days - make sense?

 

IF({DEV WEIGHT}='NONE', BLANK(), 

IF({DEV WEIGHT} = "NONE", DATEADD({OVERVIEW SUBMITTAL}, -0, 'days'), 

IF({DEV WEIGHT} = "SMALL", DATEADD({OVERVIEW SUBMITTAL}, -14, 'days'), 

IF({DEV WEIGHT} = "MEDIUM", DATEADD({OVERVIEW SUBMITTAL}, -28, 'days'), 

IF({DEV WEIGHT} = "LARGE", DATEADD({OVERVIEW SUBMITTAL}, -56, 'days'),

IF({DEV WEIGHT} = "X-LARGE", DATEADD({OVERVIEW SUBMITTAL}, -90, 'days'),

DATEADD({ADD TIME TO DEV},'days')

))))))
Sho
11 - Venus
11 - Venus

In this case, how about this formula?

SWITCH({DEV WEIGHT},
  "SMALL", DATEADD({OVERVIEW SUBMITTAL},-14-{ADD TIME TO DEV}, 'days'),
  "MEDIUM", DATEADD({OVERVIEW SUBMITTAL}, -28-{ADD TIME TO DEV}, 'days'),
  "LARGE", DATEADD({OVERVIEW SUBMITTAL}, -56-{ADD TIME TO DEV}, 'days'),
  "X-LARGE", DATEADD({OVERVIEW SUBMITTAL}, -90-{ADD TIME TO DEV}, 'days'),
  DATEADD({OVERVIEW SUBMITTAL}, 0-{ADD TIME TO DEV}, 'days')
)

Even if "ADD TIME TO DEV" is blank, it is not supposed to be an error.