Forum Discussion
MCFNeil
8 years agoQrew Captain
Hey Pam,
Hope you are doing well. I'm going to give this a crack.
It would help if you set up 'variables' and then added them together later. It helps with reading and debugging.
Variables are formatted as:
var {type} Name=evaluation;
I also like to start with the most simple and build the complexity.
We need to find the "Due Date" even though that keeps moving and we only worry about the # of days that it gets pushed.
Field [Days Remaining] formula:
""""""
var number RunTime=ToNumber([Run Time]);
var number NoteOneToResubTwo=ToDays([Resubmittal #2]-[Notification #1]);
var number NoteTwoToResubThree=If([Relates]=true, ToDays([Resubmittal #3]-[Notification #2]), null);
var date DueDate=
[Start Date]+Days($RunTime)+Days($NoteOneToResubTwo)+Days($NoteTwoToResubThree);
ToDays($DueDate-Today())
""""""
Field [Expiration Date] formula: coming soon
Field [Notification 1 Forecast] formula: coming soon
Hope you are doing well. I'm going to give this a crack.
It would help if you set up 'variables' and then added them together later. It helps with reading and debugging.
Variables are formatted as:
var {type} Name=evaluation;
I also like to start with the most simple and build the complexity.
We need to find the "Due Date" even though that keeps moving and we only worry about the # of days that it gets pushed.
Field [Days Remaining] formula:
""""""
var number RunTime=ToNumber([Run Time]);
var number NoteOneToResubTwo=ToDays([Resubmittal #2]-[Notification #1]);
var number NoteTwoToResubThree=If([Relates]=true, ToDays([Resubmittal #3]-[Notification #2]), null);
var date DueDate=
[Start Date]+Days($RunTime)+Days($NoteOneToResubTwo)+Days($NoteTwoToResubThree);
ToDays($DueDate-Today())
""""""
Field [Expiration Date] formula: coming soon
Field [Notification 1 Forecast] formula: coming soon
MCFNeil
8 years agoQrew Captain
Field [Expiration Date] formula: Basically what I called 'DueDate' above.
var number RunTime=ToNumber([Run Time]);
var number NoteOneToResubTwo=ToDays([Resubmittal #2]-[Notification #1]);
var number NoteTwoToResubThree=If([Relates]=true, ToDays([Resubmittal #3]-[Notification #2]), null);
[Start Date]+Days($RunTime)+Days($NoteOneToResubTwo)+Days($NoteTwoToResubThree);
var number RunTime=ToNumber([Run Time]);
var number NoteOneToResubTwo=ToDays([Resubmittal #2]-[Notification #1]);
var number NoteTwoToResubThree=If([Relates]=true, ToDays([Resubmittal #3]-[Notification #2]), null);
[Start Date]+Days($RunTime)+Days($NoteOneToResubTwo)+Days($NoteTwoToResubThree);