I have a list with 7 fields, I use to upload a large amount of rows using datasheet view (copy and paste from excel), one of that fields is a Date (date format), but sometimes I want need to put some text in that field, is their any way of allow that text to be insert but mark that row as a error to be treated ?

  • Did you get it working? – Hardik Jun 6 '16 at 20:15
  • are you able to copy data in list using datasheet view? did the below answer helps you? – Hardik Jun 7 '16 at 11:51

You can not simply paste the wrong data to field which type is not DateTime.

You need to make that column as string but after that you can not check if the correct date is entered to that column or not as it is going to accept the date as string

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.