j
jiawei.kek
Merged in a post:
Table: Basic Mathematical Operations in Tables
jack-s
◾Sum columns/rows
◾Sum, multiply, divide numbers, percentages
◾Sum, multiply, divide a numerical values in a cells
◾ ...❓
j
jiawei.kek
Merged in a post:
Add calculation for number fields in table
datht.official
You know, when there is a number field, for example, pricing, I want to have sum of the whole price column, or anything relatable (mhmm, notion type shi mhmmmm)
datht.official
Oh and sorting by column too, such a good feature for handling tables
j
jiawei.kek
datht.official: Hi there, are you referring to sorting tasks in the table view? this can be accessed by clicking the triple dot icon next to the Tasks column. do let me know if I understood you correctly.
datht.official
jiawei.kek. Yeah it is, but it's only sorting default column, not customized column, for example: price as custom number type column
Narek Zograbian
Merged in a post:
🔢Custom Fields: Use Advanced Formulas
jack-s
Idea:
◾Advanced Formulas
◾Date and time functions in Formulas
◾Logic functions in Formulas
◾String functions in Formulas
◾Mathematical functions in Formulas
◾Formula Fields
Narek Zograbian
Hey there! Where would you like this to show up? At the end of the table?
jack-s
At first, yes.
🤔
But in the examples I gave, it could also be an additional field in a row that will perform calculations based on other fields in the same row.
It could be something like formulas in Excel.
Narek Zograbian
jack-s: Almost like a formula field? Would this be a one-off for a row, or something that applies to each row in the table?
jack-s
Each row in the table
t
taylorkayln
Narek Zograbian like a total row to sum/count/avg (& more using formulas) each column in the Board as well as Project level.
Narek Zograbian
jack-s Thank you for clarifying!
Narek Zograbian
taylorkayln Thanks for clarifying!