Project Status Dashboard
Project Status Dashboard
TABLE WITHOUT ID
file.link as "Project",
status as "Status",
priority as "Priority",
due-date as "Due Date",
(date(due-date) - date(today)).days as "Days Left"
FROM #project
WHERE status != "completed"
SORT priority ASC, due-date ASC