What I’m trying to do
Hi,
at first I tried to implement my idea using tags, because I assumed that the hierarchical autocomplete feature of tags would provide a significant advantage.
(see original post: Tracking time in projects and tasks with tags)
However, these advantages can also be achieved when using regular properties.
My goal now is to do the evaluation using Bases and Formulas.
Things I have tried
Each completed task gets its own file, structured in the format
YY-MM-DD – Task title.
These task files are created from a template that contains the following properties:
- Who (Which person completed the task?)
- What (What was done?)
- time (How many minutes were spent?)
For evaluation, I want to use a base that could be structured like this (see screenshot).
My idea is to add two additional formula columns that use an if condition to only show the value from the time property if the Who property is either Person 1 or Person 2.
In column 1, I tried the following formula:
if(note.who == "Person 1", note.time, 0)
But this did not work.
→ Do you have any tips or suggestions?
