# Re: IF FORMULA HELP

Solved
687 0
cancel
Showing results for
Did you mean:
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},
)))))))
1 Solution

Accepted Solutions
11 - Venus

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

``````SWITCH({Stage},
)``````
3 Replies 3
11 - Venus

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

``````SWITCH({Stage},
)``````
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'),

))))))
11 - Venus

``````SWITCH({DEV WEIGHT},