How to save google sheet formula to an string variable?

Help Studio
, ,
1

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 !

1 Like
2

Hi @Alvin_Apostol1

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

Thanks

3

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.

4

Thank you for your inputs @jeevith

5

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