Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jul 13, 2023 11:33 PM
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?
Solved! Go to Solution.
Jul 13, 2023 11:49 PM
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')
)
Jul 13, 2023 11:49 PM
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')
)
Jul 21, 2023 11:44 AM
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?
Jul 21, 2023 05:20 PM
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.