This content has been marked as final. Show 2 replies
1 of 1 people found this helpful
create a calculation like below
If [your Date] = [today date] then [your meausre]
elseif [Order Date] = [today date] - 1 then [your meausre]
also filter your sheet with this new field and show only non-null values.
Thanks, Aravind. That worked.