Forum Discussion

faye_m_cook's avatar
faye_m_cook
Copper Contributor
Oct 15, 2024

Need to display a value only based on a date.

I have a dashboard showing a sum of specific values. I want to display the ending value each day so that I can see day by day if it has changed.

 

 

So today, we have 268 total orders in review (far right top), 5 edits required (second value last column), 0 questions, 462 complete, and etc. I want that column to automatically convert to a value only in another cell located on another tab once the date changes to tomorrow so I can see day by day if that number changes. The current value is using a count ifs formula.

 

Is this possible?

  • mathetes's avatar
    mathetes
    Silver Contributor

    faye_m_cook 

     

    Is this possible?

     

    I'm sure it's possible--although that is a leap of faith because I'm not exactly clear on what "it" is.

     

    Your description, absent a visible or actual example of the workbook in question, is a bit too abstract to know precisely what you mean. I suspect that may be why, after 40+ views you've gotten no response.

     

    So I invite you to post a copy of the actual workbook, or--if the actual contains confidential data--a reasonable enough mockup devoid of the names of products/customers, etc. Post it on this forum using drop and drag below the message window, or if that doesn't work, use OneDrive or GoogleDrive and paste a link here that grants access.

      • mathetes's avatar
        mathetes
        Silver Contributor
        Well, you posted an image. What I requested was a copy of the actual workbook (or a mockup). The image, despite being allegedly a 1,000 words, isn't something anybody can actually work with....

Resources