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?
Are you updating only the name column?
Or does it contain other columns as well…i guess the formula is getting rewritten
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
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
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
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.
Did you try using the Read Cell formula at start of your workflow and later using it while writing and auto fill range?
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.