Forum Discussion
Ariela Daniels
May 08, 2018Copper Contributor
How to maintain formula/link as I reorder cells via sort?
Hello I have searched for the answer to this problem but keep getting how to create a constant which is not exactly what I need. So am posting it as a question... hopefully someone can help :) ...
SergeiBaklan
May 07, 2021Diamond Contributor
I'd add another column for calculations like
assuming you have two records per day and description is the same. Formula depends on your version of Excel, but this one shall work on all
=[@Sum]+
IF([@Description]="Internet/Phone",
0,
70*0.9+(
INDEX([Sum],
MATCH(1,
INDEX(([Date]=[@Date])*([Description]="Internet/Phone"),0),0) ) -
70)*0.8
)