This document has been translated using AI. There may be some abnormalities in the expression.
I have delved into the intriguing mechanism of the advanced formula editor, available for business plan or higher. While the content may be somewhat esoteric, I implore those with an interest to peruse it.
Note: This information is based on verification as of September 22, 2023 and is subject to potential changes in future updates.
In the advanced formula editor, one can define arithmetic operations utilizing constants for fields or within fields. For example:
By utilizing such calculations, the presentation format of time fields such as actual time and estimated time can be altered. I have conducted an examination to observe how the display format varies based on the type of view.
|View||With advanced formula editor, for fields or multiplication/division operations on fields||With advanced formula editor, for addition/subtraction operations on fields||Without using advanced formula editor, Custom fields|
|Task details screen||︎||︎||△|
|Adding comments with rules||︎||︎||︎|
︎: The format varies depending on the magnitude of the value - week:day:hour:minute
△: The format is independent of the value’s magnitude - hour:minute
︎: The format is independent of the value’s magnitude - minute
Therefore, I have discovered that one can select the desired display format only on the list view, task details screen, and dashboard.