Forum Discussion

Valavan Balasubramaniam's avatar
Valavan Balasubramaniam
Copper Contributor
Apr 21, 2018

CountA as of

Hi Team, Need a help for this, I have a columns called "Assigned" and "Completed". They both are getting updated multiple time each day as new assigned and completed. When I create report for each...
Formulas and Functions
Valavan Balasubramaniam's avatar
Valavan Balasubramaniam
Copper Contributor
Apr 23, 2018

Thanks Sergei,

 

the merged column on the far left does not exist in my data. I have just created to show the difference of data entry date.

What I am trying to do is, calculate all from todays date and display. Once data refreshed tomorrow, today's data remains same and tomorrow data display as accumulated (Today + Tomorrow). 

Actually data coming from SharePoint list refreshed regularly but need to produce report for each day.

 

FYI - 

I have formulae worked out to refresh everyday and showing week worth of date on the left. When the new week comes it refresh automatically.

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Apr 23, 2018

Okay, I see. And when you refresh the list how do you know which records were added today, yesterday or day before yesterday?

 

If no such marks you may COUNT/COUNTA entire list by the end of each day and copy/paste results as value. 

Resources