Adding row values based on date
Hello Smartsheet Community,
I am trying to create a reconciliation system in Smartsheet for the on-hand count vs the dispensed count of an item. The idea is to have the end user submit a morning count of 3 different products every morning. Through another form, submit a dispensed amount for the products throughout the day (will be multiple form submissions per day). A 3rd form will be filled out by the end user for restock counts.
In the Smartsheet, I am trying to take the morning count minus the dispensed amounts through the day and reconcile it to show a match or discrepancy against the next morning's count,
Any help on this would be greatly appreciated
Help Article Resources
Check out the Formula Handbook template!