Skip to Main Content

Share your product feedback

today() in custom worksheet fields

make this value available in custom worksheets. 

  • Attach files
      Drop here to upload
    • Vitor Lory
      Reply
      |
      Mar 15, 2025

      I agree with the comments here. Worksheets are part of the Advanced plan and we get fewer functions than on the standard report where today() is available.
      We are a recent adopter of Roadmaps and Ideas Advanced, but this is a 5-year-old idea, so I wonder if it will ever come.

      Shall I give up and look for other options?

    • Tom C
      Reply
      |
      Aug 21, 2024

      FOR four years folks have been asking for this. It should get to the top of the priority stack based simply on age. Yes, we need () function to calculate values for a lot of reports.

    • Eliza Crawford
      Reply
      |
      Jul 31, 2024

      We desperately need this functionality. We want to create a worksheet field where I can auto-calculate the current stage of the feature based on today's date - if one of the field's date value is > today() then set value to X, otherwise, set it to Y. I can't do this currently and we're having to rely on a script runner to auto-populate a custom field.

    • Susan Davis
      Reply
      |
      May 16, 2024

      As part of our prioritisation method we use Weighted Shortest Job First, one of the values we use in this calculation is the number of months between today and when the Epic needs to be completed in order to realise the value, where the shorter the time, the greater the score until the date has passed and it drops to 0. To do this we need the today function. At present we have only been able to use the list view but it means we cannot put the WSJF score on the Epics nor use the in built prioritisation functionality of Aha! with a scorecard, as both would need the today function to work in Worksheets on the Epics. As such it is difficult to use properly as a prioritisation tool. As such this functionality would be incredibly useful.

    • Harry Thompson
      Reply
      |
      Sep 5, 2022

      It's incredibly frustrating that this is not possible in worksheet fields...if Aha can calculate "Days to complete by" as an out-of-the-box function, why can we not reference the current date in other calculations?

    • Swati S
      Reply
      |
      May 24, 2022

      We need the today() function to calculate YTD and PVA values for a lot of reports.


    • Alex B
      Reply
      |
      Feb 27, 2021

      I'm trully puzzled why this is not available and has not been implemented in a year. This is one of the most basic functions which is essential to making dynamic worksheets using dates. We need this funcitonality implemented ASAP. Currently our executvie-facing reports are requiring our team to manually update related fields and hard code them with the current date. Our reports are no longer dynamic.

    • Rose Russell
      Reply
      |
      May 15, 2020

      I also need the today function to work in worksheets. I have ROI formulas that need to know if this Master feature will ship in the current year.

    • +1
    1 MERGED

    Include Today() support in worksheet custom fields

    What is the challenge? Currently this equation/function is not supported in worksheet type custom fields What is the impact? Not being able to use current date as part of equations is an obstacle when wanting to track changes, monitor specific dat...
    Mats Hultgren 12 months ago in Account settings 0 Future consideration
    1 MERGED

    Use today() with custom worksheets

    What is the challenge? I need to be able to build a custom formula in a worksheet to determine when a proxy vote (which includes opp information) is expired/ no longer active. What is the impact? We have proxy votes representing expired opportunit...
    Guest 5 months ago in Features 0 Future consideration