Hi,
I have tried to create a virtual column to SUM de values of each columns before the last column not blank. I tried to use the date because it is always more current
In this case the sum should be 200
Column 1 | Date 1 | Column 2 | Date 2 | Column 3 | Date 3 | Column 4 | Date 4 | Column 5 | Date 5 |
50 | 12/15/2023 | 50 | 12/20/2023 | 100 | 12/25/2023 | 20 | 12/30/2023 |
Is there any way to do this?
Solved! Go to Solution.
Hey man,
you could do something like that:
Virtual Column App Formula =
IFS(ISBLANK([Column2]), [Column1], ISBLANK([Column3]), [Column1]+[Column2], [Column3], TRUE, 0)
and so on, depending on how many columns you actually got in your table...
User | Count |
---|---|
28 | |
14 | |
3 | |
3 | |
3 |