How to write formula in a write cell activity

Help Studio
, ,
1

Please look into the attachment and guide me where am I doing wrong
Doubt in Uipath2.xlsx (107.9 KB)

2

Hi @Muthu_Selva_Karthikeyan

Check this

cheers

4

@Muthu_Selva_Karthikeyan

Please try like this



"=IF(OR(B" + CellIndex.ToString + "=""Tagged as FTR"",B" + CellIndex.ToString + "=""Not Tagged as FTR""),IF(A" + CellIndex.ToString + ">30,""Movie"",""PackageFile""))"

Please replace the inverted comma again in your code if you are copy pasting

cheers

5

Thank you so much Anil, you are fantastic. But one more help. The formula applies the rule only in one cell. it does not iterate to the entire row. Can you please help me out with this?

1 Like
6

Hi @Muthu_Selva_Karthikeyan

Once you paste it in the first cell use auto fill range to fill remaining rows

Cheers

7

Thank you so much, Anil. That’s what I did to complete my task. But I can’t able to do that by iterating through each row. Once again thank you so much for your wonderful help

1 Like
8

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