Write Range is not working properly

Hi Everyone,

I’ve been using the Write Range for formula input but doesn’t seem to write in the range that I have input.
image

Any help will be much appreciated.

Hi

Are you writing the formula for multiple cells are one cell?
you can use write cell to write formulas that will work better

Hi Abisha,
Thank you for your response.

Yes I’m writing a formula in multiple cells. I have also tried Write Cell method but doesn’t input the correct formula that I have declared because my formula has many “” that’s why uipath declares short string

If possible can you share screenshot or xaml file?

Hi Abisha,

Here is a sample xaml :slight_smile: Main.xaml (10.3 KB)

Hi,
i have checked your workflow. Why does it write as false ?

Hi Vishal,
Because when I use Write Cell activity, it doesn’t write =IF(C2="","",VLOOKUP(C2,Grade!$A$1:$B$5,2,TRUE)) which is my formula

but it writes

=IF(C2=",",VLOOKUP(C2,Grade!$A$1:$B$5,2,TRUE))

thats why it returns to false

Try this in the write range
"=IF(C2="""","""",VLOOKUP(C2,Grade!$A$1:$B$5,2,TRUE))"

1 Like

Wow thanks! It worked!!! :smiley:

2 Likes

happy learning :slight_smile:

1 Like

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