This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hi!
I am trying to sum certain values from a specific row and column and I don’t know how to do it. Better to explain it with an example:
In this image I am trying to get the following value in the third column: (1 + 2 + 3 + 4) / 4 = 2.5. That is, ...
Hello everyone!
I’ve got several cols (days of the week) that have a time that I wasted in doing a task in minutes (ex: 120). All that I’m trying to do is a SUM of this minutes but in a h:mm format.
Example: The task is “Book Design” and the minutes ...
Hi Justin!
Thanks for your reply. The answer of your question is that “the number of the first column is always the same”. This is doe to this number is a counter. In the first set of numbers there are 4 files (so the number of the first columns is 4...
Finally I made a formula field like this: SUM({Monday}, {Tuesday}, {Wednesday}, {Thursday}, {Friday}) * 60 and I assigned the formatting (format: duration, duration format: h:mm).
Example: Monday=1440, Tuesday=30, and the other days are equal to 0. R...
