I am working with Survey123 and whenever pasting favorite answers the default time is when those answers were recorded. Is there any way to format the date function in excel so that the default time is still the current time? Thanks!
Just to check, you want the date/time question to match the current date/time each time the survey is open/edited, regardless of the time that was saved in the Favorite answers, have you tired using the now() function in the calculation field?
There is a difference in the way that defaults and calculations are applied to the survey, defaults only get loaded on initial startup of the survey, however calculations are evaluated and applied every time something changes int he survey.
Retrieving data ...