Added days until done

Jira To Sheet Pivot Formlas

//Name
=IFNA(QUERY('Jira sync'!A:O, "select O where B = '"& parent & "' AND A = 'Epic' LIMIT 1",0), "")

//Project
=IFNA(QUERY('Jira sync'!A:C, "select C where B = '"& parent & "' AND A = 'Epic' LIMIT 1",0), 0)

//Risk
=IFNA(QUERY('Jira sync'!A:M, "select M where B = '"& parent & "' AND A = 'Epic' LIMIT 1",0), 0)

//Risk Reasoning
=IFNA(QUERY('Jira sync'!A:N, "select N where B = '"& parent & "' AND A = 'Epic' LIMIT 1",0), 0)

//Status
=IFNA(QUERY('Jira sync'!A:F, "select F where B = '"& parent & "' AND A = 'Epic' LIMIT 1", 0), "")

//Progress%
=IFERROR(IFNA(QUERY('Jira sync'!A:J, "select SUM(E) where J = '"& parent & "' AND F = 'Done' label SUM(E)''",0), 0)/(IFNA(QUERY('Jira sync'!A:E, "select E where B = '"& parent & "' AND A = 'Epic' LIMIT 1",0), 0)), 0)

//Estimated MD
=IFNA(QUERY('Jira sync'!A:E, "select E where B = '"& parent & "' AND A = 'Epic' LIMIT 1",0), 0)/60/60/8

//Time spent MD
='Time Spent'/60/60/8

//Start date
=IFNA(QUERY('Jira sync'!A:L, "select L where B = '"& parent & "' AND A = 'Epic' LIMIT 1",0), "")

//Days until start
=SUBSTITUTE(DAYS(MAX(IFNA( IF(ISBLANK(QUERY('Jira sync'!A:L, "select L where B = '"& parent & "' AND A = 'Epic' LIMIT 1", 0)), 0, QUERY('Jira sync'!A:L, "select L where B = '"& parent & "' AND A = 'Epic' LIMIT 1", 0) )  , 0), today()-1000),
    today()), -1000, 0)

//Due date
=IFNA(QUERY('Jira sync'!A:H, "select H where B = '"& parent & "' AND A = 'Epic' LIMIT 1",0), "")

//Days until done
=SUBSTITUTE(DAYS(MAX(IFNA( IF(ISBLANK(QUERY('Jira sync'!A:H, "select H where B = '"& parent & "' AND A = 'Epic' LIMIT 1", 0)), 0, QUERY('Jira sync'!A:H, "select H where B = '"& parent & "' AND A = 'Epic' LIMIT 1", 0) )  , 0), today()-1000),
    today()), -1000, 0)