Hi and welcome @Svenja_Rossig!
The formula you mentioned should work as is, but is of course dependant on how you determine a task completed or not. The mentioned formula only conciders if {Completed} has ANY value, not what that value might be. If you have a single select field to determine status, you would use something like below instead.
IF({Name of status field}='Completed',
'
',
'
'
)
If the above doesn’t work in your case, then I would need to know a bit more about how you detemine a task completed (by formula, by single or multiple select field etc.?) to help.
Thank you so much in advance!!
So I actually have a multiple select field with 3 options, Todo, In progress & done.
For each option I’d like the task name to show up with a distinguished emoji behind it.
So “Write Script” with the status “To do” should turn into “Write script
”, or “Write Script
” when done or “Write Script
” when in progress…
So that the task name, which will show up in the project table in the linked column, will show me right away which tasks are yet to be done…
Does that make sense?
Okay I solved it, it’s a bit unconventional but in case someone faces the same issue, here it is:
- In tasks, duplicate the name field
- Also in tasks, make a “condition” or “Symbol” column
- The symbol column now acts to pull in the designated symbol, so
IF({Status}=“To do”,“
”,
IF({Status}=“In progress”,“
”,
IF({Status}=“Done”,“
”, " ")))
Now in the duplicated name field, use formula “Task & Condition”, which takes your task Name and adds the symbol
In the project table, link to that combined last field now
Hide our work fields in tasks
Done
Okay I solved it, it’s a bit unconventional but in case someone faces the same issue, here it is:
- In tasks, duplicate the name field
- Also in tasks, make a “condition” or “Symbol” column
- The symbol column now acts to pull in the designated symbol, so
IF({Status}=“To do”,“
”,
IF({Status}=“In progress”,“
”,
IF({Status}=“Done”,“
”, " ")))
Now in the duplicated name field, use formula “Task & Condition”, which takes your task Name and adds the symbol
In the project table, link to that combined last field now
Hide our work fields in tasks
Done
That’s great that you found a solution.
When checking the same field for multiple values in a formula you can use a SWITCH()
function instead.
This assumes you have a {Status} field and a {Name of Task} field.
You can use this right away in the primary field or in a secondary and use a lookup to pull it into the linked table.
SWITCH({Status},
'To do',{Name of Task}&'
',
'In progress',{Name of Task}&'
',
'Done',{Name of Task}&'
'
)
Yeeees!! Das ist genau das, was ich gesucht habe. Funktioniert einwandfrei, vielen vielen Dank!