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.
1 Like
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
How do you create order for this?
im creating with my orders app but its not reflecting the data in it.only what you order is there.
Hi Uzo
Thanks a lot.its working greatly.
1 Like
Hi
Why my app are no t updating and working but editor works.