Skip to main content
A
ailiescu
Cadet | Tier 2
April 18, 2022
Question

Set cell formula

  • April 18, 2022
  • 1 reply
  • 138 views

Hello!

 

I'm trying to add a formula in excel. This is the formula

=TRANSPOSE(Table1) which I enter in "set cell formula"

 

When I run the bot it adds this @ character to the formula in excel, and the formula doesn't work properly. 

Table 1 is defined in excel. 

 

=@TRANSPOSE(@Table1)

 

Thanks!

    1 reply

    A
    Automation Anywhere Team
    Automation Anywhere Team
    Automation Anywhere Team
    July 28, 2022

    Hello,

     

    I request you to please create one variable and add this formula to that variable and use the same in the set cell formula command.

     

    If you have any questions please let me know.

     

    Thank you,

    Prabhakar Jha

    Terms & ConditionsAccessibility statement