How to retain Excel Formula?

Help Studio
1

The formula under column C kept disappearing after i run the file to update the NAME under Column B. How to retain the formula or is there any other method?

2

@monicaong0609

Are you updating only the name column?

Or does it contain other columns as well…i guess the formula is getting rewritten

Cheers

1 Like
3

yes i only need to update the name column. I did tried to change the range to (“A”) but it messes the data up, not sure why

4

@monicaong0609

Use Write activity and write in C2 as =RIGHT(B2,3)
Now use AutoFillRange activity to copy paste the formula from the C2 to all the values

Hope this may help you

Thanks,
Srini

1 Like
5

@monicaong0609

If tou are writing a datatable make sure you use a filter datatable activity and keep only Name column which is B …and then use write range with B2 as range

Cheers

6

Hi @monicaong0609

After updating the values in Column B, you can use UiPath activities (such as Write Cell or Write Range) to reapply the formula to Column C. You can either write the formula directly to each cell in Column C or use autofill functionality to apply the formula across the entire column.

Thanks!!

1 Like
7

Hi @monicaong0609

Did you try using the Read Cell formula at start of your workflow and later using it while writing and auto fill range?

1 Like
9

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