One of the feature of Appsheet is , when your internet is down all the data is stored in your device cache. When internet becomes active again, it will sync with your datasource. So always there is sync between device and datasource. That is the reas...

Try using if condition which takes 3 inputs, in that keep a condition to find the time difference of 1 day. In "if expression " you will be having another 2 expression based on yes/no output of condition. In those try de-referencing the closing stock...

Check out this app for reference https://www.appsheet.com/samples/dynamic-slice?appGuidString=91266cff-e843-46b8-a42b-3d85afedb37f

@PagHonduras your solution might have worked for now. But there could be few issues with your approach in future, like one is “data inconsistency”.I mean let say,what if “Supervisor” spell changed or removed in spreadsheet? In that case here in the A...