Generic Function based on the above row
Hi Guys,
I am introducing a new column titled 'Delta' where each cell's value relies on the value of the cell directly above it, as illustrated below:
in row#15, I have this code: =IF((ISBLANK([ColumnA]@row)), Delta14, [ColumnA]@row  [ColumnB]@row + Delta14)
in row#16 I have this code: =IF((ISBLANK([ColumnA]@row)), Delta15, [ColumnA]@row  [ColumnB]@row + Delta15)
in row#17, I have this code: =IF((ISBLANK([ColumnA]@row)), Delta16, [ColumnA]@row  [ColumnB]@row + Delta16)
and so on... in general, I want a generic function in row#X where the code is: =IF((ISBLANK([ColumnA]@row)), DeltaX1 , [ColumnA]@row  [ColumnB]@row + DeltaX1)
Your assistance with this matter would be greatly appreciated :)
Answers

I don't think it can be done with current formulas. Is there a pattern in your data or other logic that could be used to determine what the value in the cell above should be?
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

@Mark Cronk Nope, currently I am using the formula inserted above, but the problem appears when I insert a new row in the middle or delete a row.
Is there any workaround to overcome this? I did review almost all previous discussions without any clue.

To create a generic function on row #X that depends on the value of the cell above it and the previous value of the Delta column, you can use the following approach. You need to simply use the DeltaX1 expression as the value if the current cell in ColumnA is empty, otherwise calculate the difference between the current row's values in ColumnA and ColumnB and add the previous value of the Delta column. This approach will ensure that the function works correctly for any row X, using the values of the previous rows and the current row.

@ BraylenStanton I'm currently doing just that, but I'm struggling to generalize it. Instead of using terms like DeltaX1, I find myself consistently resorting to specific numbers like Delta14, Delta15, Delta16, and so forth.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.4K Get Help
 364 Global Discussions
 200 Industry Talk
 428 Announcements
 4.4K Ideas & Feature Requests
 137 Brandfolder
 129 Just for fun
 128 Community Job Board
 446 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!