Forum Discussion
Can Forms 365 add a calculated field
- Jul 24, 2021
joZ99 no, unfortunately there is no functionality that lets you do calculations like that. If the people completing the form were in your organisation you could create a Power Apps form which does allow you to build quite complex calculations. But from your question I assume that people will be outside your organisation you'll need to use a non-Office 365 app like Jotform.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
joZ99 no, unfortunately there is no functionality that lets you do calculations like that. If the people completing the form were in your organisation you could create a Power Apps form which does allow you to build quite complex calculations. But from your question I assume that people will be outside your organisation you'll need to use a non-Office 365 app like Jotform.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
Thanks so much for your reply.
Unfortunately, my forms go to adult "students" and so all of them are outside the 365 organization.
It is just the three of us, me, myself and I, that is sending it to 100+ recipients. I appreciate the advice on another App... I will either try a work around with Forms 365... get them to use their own amazing Math skills to add up numbers and write down their answer, and/or I will start looking at Jotform. It seems like such a simple "add-in" to be able to "add-up" but as I am not a techy I am sure it is challenging to create install into Forms 365. Maybe someday soon so I can return it using it.
What a great resource this Forum is as I have tried asking this same question by phoning Microsoft and none of their experts had expertise in Forms.
Thanks again...