1

We have created a Google form that works perfectly, there is only one issue, and that's the DATE selector, it sends the DATE, but we would like to receive the DATE and the WEEKDAY in the form we receive by e-mail.. is that possible in any way? Have seen many ways for Google Sheets, but nothing for Google Forms... I'm completely new to this so excuse if I ask something stupid, also I have looked in the addons section but there is nothing for weekdays or an enhanced date :)

0

This is usually done in post-processing with simple array formula which derives weekday from dates collected by the form.

={"weekday"; ARRAYFORMULA(IF(LEN(A2:A), WEEKDAY(A2:A, 1), ))}

0

={"weekday"; ARRAYFORMULA(IF(LEN(A2:A), TEXT(A2:A, "dddd"), ))}

0

  • Thanks a lot for the long reply :) We actually don't normally go into the replies sheet, we just take a look at the e-mail the form sends automatically. I will have to look for a way to get the great info you explained into the sheet and that it then sends it by e-mail. – Robert May 6 at 9:07

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.