Display Google Sheets Formula Output in Typeform | Community
Skip to main content
Answered

Display Google Sheets Formula Output in Typeform

  • September 12, 2022
  • 2 replies
  • 94 views
G

Hi,

 

I want to create a Typeform where the output of Google Sheets formulas are displayed within the form

e.g. if they type in that they have 200 employees, and I know that 10% of employees quit each year, can I display as a statement that - statistically speaking - 20 of their employees will quit in the next year?

Essentially, I want to perform a calculation that displays a % of the number they input back at them…

Is that possible - I assume it is with Google Sheets integration? Please help!

 

thanks,

Archie   

Best answer by Liz

Hi @GingerNinja05 Happy Monday! When the respondent is filling out the form, all of the questions need to be pre-set, and it isn’t possible to reference outside information, such as Google Sheets. 

What kind of calculations are you looking to have? Depending on the complexity, it may be possible within the form itself. 

View original

Liz
Community Team
Forum|alt.badge.img+5
  • Liz
  • Tech Community Advocate
  • September 12, 2022

Hi @GingerNinja05 Happy Monday! When the respondent is filling out the form, all of the questions need to be pre-set, and it isn’t possible to reference outside information, such as Google Sheets. 

What kind of calculations are you looking to have? Depending on the complexity, it may be possible within the form itself. 

Life is a series of awkward moments separated by snacks.
john.desborough
1 person likes this
  • john.desborough
    john.desborough
Gabi Amaral
Ex–Typefomer
Forum|alt.badge.img+5
  • Gabi Amaral
  • Ex–Typefomer
  • September 21, 2022

Hey @GingerNinja05! Welcome to our Community! 

Were you able to check Liz' reply above? Make sure to let us know what kind of calculations you're looking to have!

Looking forward to hearing back from you! 😉

Everyone you meet is fighting a battle you know nothing about. Be kind. Always. =)
john.desborough
1 person likes this
  • john.desborough
    john.desborough

Reply


Still need help?

Don't be shy and ask the community.

Ask your question here!
Community T&Cs