Hashtag sign in account field in time entry
Hello,
We are using excel to copy and paste data into time entry.
In excel, we use formulas to populate some cells to save typing time but we have detected that if we have an error in one of these cells which in excels shows a value like #DIV/0!, or #NUM!, or #NAME? these errors values are transferred into the time entry application and as long as a hashtag is in front of the error, we are able to save the record without yellow warning or red error.
This is an screenshot of what I am able to enter.
as we use this excel method to copy and paste many records at once, sometimes we miss this error values. Is it any way to prevent this to be saved? Is there any reason why we can save an account that does not exist as long as the hashtag is in front?