Hi Everyone, I am trying to insert a formula to a google sheet however I can’t seems to assign it on a variable I’m I doing it wrong? Please refer below: [image] as you can see I already enclosed the string with " " symbol. Please advise and let me know Thanks !

HI @Alvin_Apostol1 , In UiPath double quotes require some TLC! Since Google does not support single quotes 'STRING' on string values Single quotes in Google Sheets [image] Double quotes in Google Sheets [image] So we know, we can not use 'STRING' in UiPath as Google Sheet wont support it. Sol…

How to save google sheet formula to an string variable?

Help Studio

prasath_S (prasath S) August 5, 2021, 4:12am 2

Hi @Alvin_Apostol1

Please put ““yes”” instead of “yes” and ““no”” instead of “no”

Thanks

Topic		Replies	Views
Assigning Excel Query Formula in variable Studio excel , activities , studio	3	39	March 10, 2025
Write line: Excel formula for empty cells Help	7	2585	June 11, 2021
Can we store Excel formula value to a variable directly in Uipath Help	2	1796	September 27, 2019
How to Convert String to UiPath Mathematical formulas Studio studio , question , activities_panel	24	1777	October 11, 2022
Uipath- Excel Formula With Write Cell Activity Activities excel , activities , question	14	1129	March 20, 2022

How to save google sheet formula to an string variable?

Related topics