video1.0<iframe src="https://www.loom.com/embed/a58f9fd66ecf43918d0dcd2287d0262b" frameborder="0" width="1920" height="1440" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>14401920Loomhttps://www.loom.com14401920https://cdn.loom.com/os/loom-media-content/loom/a436116f-02ce-4520-8fbb-7301462a1674/1621dc1f-3702-4525-84ba-fad829566798/sessions-thumbnails-a58f9fd66ecf43918d0dcd2287d0262b-73721daa28110313.gif/binary?authToken=eyJraWQiOiJtaWNyb3MtZ3JvdXAvdGRwLW9zLWFyY2hldHlwZS85aWtiYzdyaXJxajEwNjVvIiwiYWxnIjoiUlMyNTYifQ.eyJicyI6Imxvb20tbWVkaWEtY29udGVudCIsImF1ZCI6InRkcC1vcy1hcmNoZXR5cGUiLCJuYmYiOjE3ODc3ODM5MzgsInRpIjoiZDYyYzFlNTgtMzIwZi00YjU5LTk4Y2ItMjQ1NzYyODBmZjA1IiwiYWRpIjoibG9vbS9sb29tIiwiaXNzIjoibWljcm9zLWdyb3VwL3RkcC1vcy1hcmNoZXR5cGUiLCJwaWQiOiI0YzdiOGJjOC0zNGJmLTRiM2ItODEyMy0wN2NlNzIwM2Y5ZTQiLCJ3YSI6ImZhbHNlIiwib2lkIjoic2Vzc2lvbnMtdGh1bWJuYWlscy1hNThmOWZkNjZlY2Y0MzkxOGQwZGNkMjI4N2QwMjYyYi03MzcyMWRhYTI4MTEwMzEzLmdpZiIsImV4cCI6MTc4Nzc4NDIzOCwiaWF0IjoxNzg3NzgzOTM4LCJqdGkiOiIwOTIzMmY0Zi00MGZlLTQ0ZjktODQ2MC02YmI4NmEzYWE3YjIifQ.FGMgen8EjwrLmGfDHF5JVg4A9xfIwaCUakWccgAmdhyBPK9jJIscOML9oWzea4E8feda8wMzd0YDoN9NYiUvtKVbl2hFSU7tBQ1ugN_ccgXQzPFSRHWVj_WNz_xvkYN0X5v0zx3kmVZnbmL8G-2Q-0ThUP-wMgHpQ0wpNfFlCaAL-LyyeBAoL5PmNSjAKxUIBs0vcpbetJPUYX_5GDYx7Use5YvW7l8Uj35WBkBIylJJH9VhaL5BSlHSiuDwGaBUL8Sa_ngHC5zNtdI3s8oKtdZIoMORl9F1JAgOsvu9w3xH8oMum5qeu8HxdHOFCLr0Nzp1_AOcCdfg-r7yy2emrg&Expires=1787870339&Signature=l49T1it7yJXzN35dKjMYPu0tqGhtPjK27etT1ZJ7gUjYdzj9j0psvnzGSr5irgtFQC1bTBP1j2pFF83UwvUEVnuVwuZ-RKhiJ9P2yuMneKEpkNPRdxxv8g-ffqo6b6aJ0jS4j8AaqxSsy2KMun6yXL%7Ew0mbH93kWQKXs6BnY-d4unjo8HSr4V%7ExbVGwNTu7XkHDa7y%7ExBmW20FBYCbP6q6NlQkf9SIbXVHl6AGbB39BZr%7EBIGhqCJnjwyQCvdv0%7EeKcf6R284-W0VFcYThIeIDRhzl9S%7EzgdI00C1PwzfPcW8bu5EYBs%7EMFPwGVoLTc3%7ENlV--xPh5RBcBkTeKPBKg__&Key-Pair-Id=KQOSYIR44AIC0215.1This Loom explains how to use Jira formula fields to run real-time calculations directly on work items. The presenter creates a formula field for budget variance by defining it as actual spend minus approved budget, so every work item updates instantly and shows over or under budget status. They then build an ROI formula with help from Robo by accepting the auto-generated formula based on fields like revenue, actual spend, and approved budget. Finally, they demonstrate conditional formatting that highlights rows in red whenever budget variance is greater than zero.