Hi, is there a way to have all formulas within a file evaluated at once? And maybe even by a trigger-event like switching from edit mode to view mode?

I’m trying to get the following table with calculations to work

| date       | activity             | duration |
| ---------- | -------------------- | -------- |
| 25-08-2021 | Activity 1           | 15       |
| 12-10-2021 | Activity 2           | 65       |
| 22-10-2021 | Activity 3           | 50       |
| 01-11-2021 | Activity 4           | 135      |
|            | Total in minutes     |          |
|            | Total in hours       |          |
<!-- TBLFM: @>$3=sum(@I..@-1) -->
<!-- TBLFM: @>$3=(@-1/60) -->

But I run into the following problem.
If I place the cursor in the third column of the second last row and press the ‘fx’ button, it just returns a 0 in the third column of the last row.
I can’t get it to calculate the two fields concurrently.

Any ideas how to get this working would be greatly appreciated.
Thanks in advance.

Hello,

Plugin options do not appear on the mobile version. Also, impossible to add quick actions “go to next cell”, “go to next row”, they don’t even appear in command panel.

1 Like