Skip to main content
Solved

IF FORMULA HELP

  • July 14, 2023
  • 3 replies
  • 24 views
Scott_Gardner1
Forum|alt.badge.img+15

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'
)))))))

Best answer by Sho

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') )

    3 replies

    S
    Forum|alt.badge.img+21
    • Sho
    • Inspiring
    • Answer
    • July 14, 2023

    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
    Scott_Gardner1
    Forum|alt.badge.img+15
    • Scott_Gardner1
    • Author
    • Known Participant
    • July 21, 2023

    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')

    ))))))
    S
    Forum|alt.badge.img+21
    • Sho
    • Inspiring
    • July 22, 2023

    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.

    Terms & ConditionsAccessibility statement