Write Range is not working properly

Build
#1

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.

#2

Hi

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

#3

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

#4

If possible can you share screenshot or xaml file?

#5

Hi Abisha,

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

#6

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

#7

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

#8

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

1 Like
#9

Wow thanks! It worked!!! :smiley:

2 Likes
#10

happy learning :slight_smile:

1 Like
#11

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