Some time data not updated, I have to refresh manually
I’m using a Smartsheet form to process bulk orders, I’m using an Excel template to fill in the bulk order details in the bulk order sheet and then using a data shuttle to transfer the information to the order summary sheet.
I’m experiencing issues with the order numbers not always appearing in the order summary sheet.
Once bulk order form submits then excel file upload in bulk order sheet and here I have one column “Order number”, here order number generated sequentially. For example, order number is 1001, and in the excel template have 5 orders.
In Order summary sheet – here I have one column “Order number”, in this column I am getting reference from “bulk order” sheet and order number is generating like, order number is 1001 into the bulk order sheet and 5 order in the excel template, so here order number is generating like 1001-1, 1001-2, 1001-3, 1001-4 and 1001-5.
It is working properly but sometimes I have to manually refresh the bulk order sheet to get the order numbers to appear in the order summary sheet. What could be causing this issue and how can I resolve it?
Note: Time zone of sheet owner and my time zone is different. when sheet owner’s time zone is US time, at that time my time is IST.