Answered

Display Google Sheets Formula Output in Typeform

  • 12 September 2022
  • 2 replies
  • 71 views

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   

icon

Best answer by Liz 12 September 2022, 22:04

View original

2 replies

Userlevel 7
Badge +5

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. 

Userlevel 7
Badge +5

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! 😉

Reply