Calculating 14 day due date

Bryan Letourneau

Hello,

I'm attempting to collect training metrics by department and I'm unsure how to incorporate a formula to identify criteria for training due 14 days from today. The below formula references a report with a Due Date column, not sure sure how to create the criteria for due dates 14 days from today.

Thank you in advance!

Amit Wadhwani

If you have due date column and you can create another column which will check the due date from today. Create another column and try the below formula, if the value is 1 then the due date is in next 14 or less than 14 days. 

=IF(Date@row - TODAY() <= 14, 1, 0)

Regards

Amit Wadhwani, Smartsheet CoE, Ignatiuz Software, Exton, PA

https://www.linkedin.com/in/amitinddr/

Amit Wadhwani

If you have due date column and you can create another column which will check the due date from today. Create another column and try the below formula, if the value is 1 then the due date is in next 14 or less than 14 days. 

=IF(Date@row - TODAY() <= 14, 1, 0)

Regards

Amit Wadhwani, Smartsheet CoE, Ignatiuz Software, Exton, PA

https://www.linkedin.com/in/amitinddr/

Bryan Letourneau

Ahh yes, didn't consider using a formula column. I appreciate the help!