How insert existing data in to one particular row

[ajayhse]

I wan to add week 14 value which is 722 only in active user rows , as it  is adding in all rows 

[v-zhangti · Accepted solution]

Hi, @ajayhse 

You can try using the IF function.

Week14 = IF([Data]="ActiveUsers",722,BLANK())

Is this the output you expect? If so, you can replace my equation 722 with the Sum formula in your figure above.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.