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...
Hi @Aurelien
I have multiple columns (5 columns are an example), and I'm exploring ways to sum the columns from first to before last as the values within these columns are populated.
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 |
---|---|
41 | |
25 | |
25 | |
17 | |
12 |