Skip to main content

I am trying to track when i should expect a project back based on the amount of days given to return. The first return length is 70 days or 10 weeks. The second time it is submitted is 30 days return. 

Column: Submitted date: (constant)- user entered 

Columns: Expected Project Return (date) 

DATEADD({SUBMITTED Date }, 10, 'week')) 
This checks out good. 
 
when I have a Resubmittal column(date) I would like the Expected Project Return Date to now show 
DATEADD({SUBMITTED }, 30, 'day')) 
So in short i want the expected return date column to update once the resubmittal date is updated. 

Calculating dates is always fun. 

In order to accomplish what you're looking for you'll need a conditional statement.

Something like:

 

 

IF(
{Resubmittal},
DATEADD({SUBMITTED}, 30, 'day'),
DATEADD({SUBMITTED}, 10, 'week')
)

 

 

Hope this helps!

Hi,
I would use the formula provided by @bcrossley  , as better readable.
Just want to show you can transform formulas  in a different ways, like put the condition exactly where you need to change the value:

DATEADD({SUBMITTED Date}, IF(Resubmittal,30,70) ,'days')

 

Calculating dates is always fun. 

In order to accomplish what you're looking for you'll need a conditional statement.

Something like:

 

 

IF(
{Resubmittal},
DATEADD({SUBMITTED}, 30, 'day'),
DATEADD({SUBMITTED}, 10, 'week')
)

 

 

Hope this helps!


Thank you for your help in resolving this. 

 

Hi,
I would use the formula provided by @bcrossley  , as better readable.
Just want to show you can transform formulas  in a different ways, like put the condition exactly where you need to change the value:

DATEADD({SUBMITTED Date}, IF(Resubmittal,30,70) ,'days')

 


Thank you for the response the line worked.

Reply


Terms & Conditions