"Record No Longer In View" / Apostrophes in Data from Dynamic View
Background information: I am trying to track allocation percentages of time that employees are dedicating towards a project, so I am having them fill out a dynamic view that has a drop down with increments of 0%-100% for each week (pictured below). The employees do not have access to the source sheet based on sensitive information being stored inside, and their view is personalized based on their email (using the 'restrict view by current user" setting).
Issue #1: When employees are filling out the dynamic view, the data is coming back into the source sheet with an apostrophe in front of the percentage (pictured below). This is causing me to manually remove the apostrophe in every cell so the downstream formulas can calculate. How do I get the Dynamic View to stop inputting the apostrophe?
Issue #2: Some employees are running into an issue when they save their data, Smartsheet pops up with an error that "record no longer in view" (pictured below). The data is still being saved down to my source sheet, it just is added to a new row, not the one with the employee's email which the dynamic view is catered towards. I am able to see who submitted the data from the cell audit history, but I am confused why it isn't just saving to the correct row in the first place. How do I prevent this from continuing to happen?