Forum Discussion
faye_m_cook
Oct 15, 2024Copper Contributor
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?
- mathetesSilver Contributor
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.
- faye_m_cookCopper ContributorI updated the post. Thank you for that.
- mathetesSilver ContributorWell, 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....
- faye_m_cookCopper ContributorThank you. Let me do that.