Why are telling these things.im not understand why you are asking me doing this.
I previously used a column to check the date is today,it’s showing today but not showing today .may I know why.
you need to convert the date to text, so it will not have a time value in it… that will be necessary to check if is the same date as today
Okay,then only it works ah? Okay.
yes, then you can use the if-else column if today is the date ordered and bring quantity for sum calculation…
(even when you change date format to just date, it still is a full date with time… that’s why you need to convert to text)
Okay.i really don’t know that’s y it’s not working.
But i will do these things and revert you.
Did you check the snacklist table.from this table only I’m retrieved the quantity count of that particular snack.
no, i only have copy… it will not update my sheet
It consists of snacklist , whenever the order comes the order tables gets updated and this snacklist table updates directly if that particular snack ordered.the count of that quantity added that is the problem I need to solve.
It’s keep on adding but this tab I need to filter by showing count of today’s order of the snack.
i corrected your columns, check if it work like you want it
Not working…
I want the snack quantity of today ordered only.but it’s summing up the previous too.i don’t know how to proceed this.
Are you checking the one i posted? It won’t change yours
It’s showing nothing in the orders to tab if i create new order. i.e today’s order,it should show right ?
Have created some orders today but it’s not showing.
Is it showing data in orders to tab for you…
Ok…i will recheck it
Hi Uzo
Thanks a lot.its working greatly.
Hi
Why my app are no t updating and working but editor works.