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.
Any help will be much appreciated.
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.
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 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))”
Wow thanks! It worked!!!
happy learning
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.