Suggestions needed for reporting # of weeks remaining

  • 1
  • Question
  • Updated 3 years ago
  • Answered
I am trying to automate a report that I currently customize in Excel. I would like to calculate number of weeks remaining prior to a project end date. For example, if a project ends on 12/1/14 and it's currently 10/9/14, I use the formula =ROUND(((A1-A2)/7),0) when the date 12/1/14 is in cell A1 in Excel and the date 10/9/14 is in cell A2. I've created a custom field at the project level and entered the project end date. Is there a current date field (or maybe just use the timesheet period end date)that I could use to create this calculation? Or is there some other way that the system could report how many weeks were remaining until the project close?

(Originally posted by kjacobs)
Photo of Archived Post

Archived Post, Official Rep

  • 2132 Posts
  • 6 Reply Likes

Posted 4 years ago

  • 1
Photo of Archived Post

Archived Post, Official Rep

  • 2132 Posts
  • 6 Reply Likes
Hi,

Thank you for using Replicon Community.

In order to obtain current date via reports you will need to set up a custom column with the formula Today().

Steps are as follows:-  - Login to Replicon - Go to Reports - Select the report for which you want to add custom columns and click Settings. - In the Report Settings window, select the Custom tab and click Add a new custom column. - Enter a name and the Today() function to the formula.  - From the Format drop-down field, select Automatic. - Click Done. - Detailed steps & the outcome are demonstrated in this video:- http://youtu.be/7AM91OQUBvg   Screenshot with steps:-   



Thanks,

Lingaraj



 

(Originally posted by Lingaraj Dharwad)
Photo of Lingaraj Dharwad

Lingaraj Dharwad, Product Champion

  • 1100 Posts
  • 46 Reply Likes
Hi All,

The video can now be viewed at the below link:

Steps to get current date on a report via custom columns

Thanks,
Lingaraj