How to save google sheet formula to an string variable?

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:

as you can see I already enclosed the string with " " symbol.

Please advise and let me know

Thanks !

1 Like

Hi @Alvin_Apostol1

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

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.


Solution : You can try this syntax in UiPath when you want double quotes:

"=IF(AND(G2=""Yes"", H2=""Yes"", I2=""Yes""), ""Yes"", ""No"")"

image

Hope this clears you doubt and now know the reason for the failure.

Thank you for your inputs @jeevith

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.