Add a Write-off Column on my Structure

nanellepeyper

Hello. I want to add an additional column in my Structure for Write-Offs. This is to calculate from my Jira report the Billed time minus the Logged time,  so I can see how much time I have written off on my tasks. I would like to do this via a formula. Can someone assist me with this formula. 

David Niro

Hello @nanellepeyper ,

If Billed Time and Logged Time are both fields on your Jira issues, you can add a formula column and use:

BilledTime - LoggedTime

If BilledTime and LoggedTime show up in red, you can map them to the corresponding fields from the variable list below the formula box.

Hope this helps!

Best,
David