Cell Data Changing Unexpectedly, Triggering Automations
I have a sheet with a form that users fill in and submit (collecting data on inventory movement in/out). This sheet & form has been working correctly since 2022. When a new form submission comes through, I have automation set up to notify a contact in a cell (new submission). I have separate automation set up to notify that same contact if any changes are made to the data in that row (submission adjustment). Last Thursday, March 20th, the sheet started to send automated notifications for both new submission & submission adjustment, at the same time or within minutes of each other. Nobody is manually making any changes to data in the row. When viewing cell history on prior submissions, you can see that dollar value comes through as $123456.00. However, every submission from March 20th on, is now coming through as $0.00, then 123456, then $123456.00. I have this exact same sheet/form duplicated for 30 other locations, and it hasn't done this to their sheets. Any insights as to why this is suddenly occurring on one of my sheets, and how I can rectify it?
Answers
-
hi @Laura McDonald,
and you are 100% sure it's not the user that is messing around with the data?
because it looks very weird for smartsheet to make those changes with data.
Experienced IT PM and the Real Smartsheet Enthusiast.
Is there anything else we can help you with? - book your time.
MASA Consult - Your Aligned Smartsheet Gold Partner
Find us on LinkedIn & Check our Smartsheet Solutions!
Tag my name: @kowal if you want me to respond :)
-
I would suggest reaching out to Support for this one. I have run into similar issues in the past, and it was something support needed to fix/clear out on the back-end of the sheet that we don't have access to.
@kowal If it was a user interacting with the data in the sheet after submission, the user listed for the change wouldn't be "Form User".
-
@kowal - no, they aren't changing anything in the sheet afterwards. They don't have direct access to the sheet, only the form. The sheet isn't published. I submitted a form myself to test/troubleshoot, and it did the same thing to me.
@Paul Newcome - thanks! I was hoping maybe someone knew a quick fix here before I went to support, but it's sounding like it's maybe something I can't fix on my own.
