- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 31, 2025 09:18 AM
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)
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 31, 2025 11:40 AM - edited ‎Jan 31, 2025 11:41 AM
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!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 31, 2025 11:40 AM - edited ‎Jan 31, 2025 11:41 AM
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!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 31, 2025 02:47 PM
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')
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 31, 2025 05:19 PM
Thank you for your help in resolving this.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 31, 2025 05:20 PM
Thank you for the response the line worked.
