Add the Date field and Number field in the spreadsheet to form widget

This would be great if the widget can look up a google sheet and also have the Date field added. I have a registration form that users complete 2 times a year and if they were able to use a unique ID to pre populate the details it would be fantastic, just need the date field added and the Number field added.

can this be done?

I think it can be done. You can just add first the Date and Number data as text data type (Textbox/Short Text Entry). The object is to populate first the Textbox field in the form with data from the spreadsheet (Date and Number data)

And then in the form, add calculation conditions that will convert the data into Date field and Number field.

You may review the related guide here.

Let us know if you need further assistance on this.