1 Reply Latest reply on Nov 4, 2016 11:31 AM by Yuriy Fal

    Today Calculation without Data

    Josh Delekta

      Hello,

       

      I am using the Today() calculation to show the current month in worksheet titles. I am trying to ensure that I don't have to go into each sheet every month and update the month manually. The title reads this:

       

      <Sheet Name> - <MONTH(Today)>

       

      Some worksheets have activity for the month. The title reads:

       

      Sheet Name - October 2016

       

      Some worksheets don't have activity for the month. The title reads:

       

      Sheet Name - All

       

      Is there a workaround for this? The first sheet always has data in it. Could I create a relationship with another sheet or data source in the workbook so that the data read off of that instead of coming up blank?

       

      Thank you!

        • 1. Re: Today Calculation without Data
          Yuriy Fal

          HI Josh,

           

          My understanding is that "All" label in the Title

          is triggered when there is no Marks on the view.

           

          I wonder what you would do with an empty view?

          Staring on it? Just kidding :-)

           

          Seriously, the above behaviour is by design 

          and it couldn't be modified / worked around (imho).

           

          Yours,

          Yuri