Force reload worked, it’s a lot better now thanks!
Last question…
How would I do conditional formatting for Task Status vs the boolean currently done.
Example 4
TABLE WITHOUT ID
regexreplace(Tasks.text, "\[.*$", "") AS Task,
choice(Tasks.completed, "🟢", "🔴") AS Status,
Tasks.completion AS "Completion Date",
Tasks.due AS "Due Date",
Tasks.created AS "Created Date",
Tasks.priority AS "Priority",
regexreplace(Tasks.subtasks.text, "\[.*$", "") AS Subtasks,
choice(Tasks.subtasks.completed, "🟢", "🔴") AS "Subtasks status",
Tasks.due - date(today) AS "Time Left"
FROM #task
FLATTEN file.tasks AS Tasks
WHERE file.tasks AND contains(Tasks.tags, "#task")
AND meta(Tasks.header).subpath = "Task List 1"
SORT default(Tasks.due, "") ASC
Line 3:
choice(Tasks.completed, "🟢", "🔴") AS Status,
Maybe something like this pseudo code
choice(Tasks.status, " " = "🔴", "/" = "🟡", "-" = "⚫️", "x" = "🟢") AS Status,