Begging for help: Output on excel formulas added an alias @ behind the equals sign

Help Activities
, ,
1

Hi all, I was trying to use the activity write cell workbook to add in a formula =MINIFS(Z:Z,E:E,E2) and the output gives =@MINIFS(Z:Z,E:E,E2) in the cell. Please help me. thanks.

2

Hi @jollie_ng

Can you try with Excel activities

A screenshot of an Excel process in an automation workflow, showing actions to use an Excel file and write a specific formula to a cell. (Captioned by AI)
A screenshot of an Excel process in an automation workflow, showing actions to use an Excel file and write a specific formula to a cell. (Captioned by AI)585×784 25.7 KB

Regards,

3

Hi @jollie_ng

If you found helpful please mark as a solution. Thanks
Happy Automation with UiPath

4

Use fill range option instead of write range

An automation flow in Power Automate is using an Excel file to fill a specified range in an ExpenseTracker sheet with a MINIFS formula. (Captioned by AI)
An automation flow in Power Automate is using an Excel file to fill a specified range in an ExpenseTracker sheet with a MINIFS formula. (Captioned by AI)717×634 22.6 KB

5

@jollie_ng

With work ookactivities you cannot add formulae..you need to use excel activities for the same

Cheers