CINXE.COM

<!DOCTYPE html><html lang="en"><head><meta charSet="utf-8" data-next-head=""/><title data-next-head="">Formula Fields | Productive Help Center</title><meta property="og:title" content="Formula Fields | Productive Help Center" data-next-head=""/><meta name="twitter:title" content="Formula Fields | Productive Help Center" data-next-head=""/><meta property="og:description" content="Learn how to create, add, and use custom formula fields in Productive." data-next-head=""/><meta name="twitter:description" content="Learn how to create, add, and use custom formula fields in Productive." data-next-head=""/><meta name="description" content="Learn how to create, add, and use custom formula fields in Productive." data-next-head=""/><meta property="og:type" content="article" data-next-head=""/><meta name="robots" content="all" data-next-head=""/><meta name="viewport" content="width=device-width, initial-scale=1" data-next-head=""/><link href="https://intercom.help/productive/assets/favicon" rel="icon" data-next-head=""/><link rel="canonical" href="https://help.productive.io/en/articles/3933649-formula-fields" data-next-head=""/><link rel="alternate" href="https://help.productive.io/en/articles/3933649-formula-fields" hrefLang="en" data-next-head=""/><link rel="alternate" href="https://help.productive.io/en/articles/3933649-formula-fields" hrefLang="x-default" data-next-head=""/><link nonce="isF+8Twgjhz0bOnKQEyoHcCnhKs3PYCbtLDdCvb3OHU=" rel="preload" href="https://static.intercomassets.com/_next/static/css/02742ed7dc6dee08.css" as="style"/><link nonce="isF+8Twgjhz0bOnKQEyoHcCnhKs3PYCbtLDdCvb3OHU=" rel="stylesheet" href="https://static.intercomassets.com/_next/static/css/02742ed7dc6dee08.css" data-n-g=""/><noscript data-n-css="isF+8Twgjhz0bOnKQEyoHcCnhKs3PYCbtLDdCvb3OHU="></noscript><script defer="" nonce="isF+8Twgjhz0bOnKQEyoHcCnhKs3PYCbtLDdCvb3OHU=" nomodule="" src="https://static.intercomassets.com/_next/static/chunks/polyfills-42372ed130431b0a.js"></script><script defer="" src="https://static.intercomassets.com/_next/static/chunks/9807.06bd1120513ccdff.js" nonce="isF+8Twgjhz0bOnKQEyoHcCnhKs3PYCbtLDdCvb3OHU="></script><script src="https://static.intercomassets.com/_next/static/chunks/webpack-914670f3d197b0ac.js" nonce="isF+8Twgjhz0bOnKQEyoHcCnhKs3PYCbtLDdCvb3OHU=" defer=""></script><script src="https://static.intercomassets.com/_next/static/chunks/framework-c2b23989aabf8846.js" nonce="isF+8Twgjhz0bOnKQEyoHcCnhKs3PYCbtLDdCvb3OHU=" defer=""></script><script src="https://static.intercomassets.com/_next/static/chunks/main-f1052d0773c47c55.js" nonce="isF+8Twgjhz0bOnKQEyoHcCnhKs3PYCbtLDdCvb3OHU=" defer=""></script><script src="https://static.intercomassets.com/_next/static/chunks/pages/_app-f6eb1f03c2a77808.js" nonce="isF+8Twgjhz0bOnKQEyoHcCnhKs3PYCbtLDdCvb3OHU=" defer=""></script><script src="https://static.intercomassets.com/_next/static/chunks/da8cbcf2-515374c1b53e94b9.js" nonce="isF+8Twgjhz0bOnKQEyoHcCnhKs3PYCbtLDdCvb3OHU=" defer=""></script><script src="https://static.intercomassets.com/_next/static/chunks/7833-842ba55e661d0800.js" nonce="isF+8Twgjhz0bOnKQEyoHcCnhKs3PYCbtLDdCvb3OHU=" defer=""></script><script src="https://static.intercomassets.com/_next/static/chunks/8277-93597e4349e635c0.js" nonce="isF+8Twgjhz0bOnKQEyoHcCnhKs3PYCbtLDdCvb3OHU=" defer=""></script><script src="https://static.intercomassets.com/_next/static/chunks/639-4cba3a85bc80cea4.js" nonce="isF+8Twgjhz0bOnKQEyoHcCnhKs3PYCbtLDdCvb3OHU=" defer=""></script><script src="https://static.intercomassets.com/_next/static/chunks/2266-6ece4d4ecd5a090f.js" nonce="isF+8Twgjhz0bOnKQEyoHcCnhKs3PYCbtLDdCvb3OHU=" defer=""></script><script src="https://static.intercomassets.com/_next/static/chunks/6408-1b0e182947803382.js" nonce="isF+8Twgjhz0bOnKQEyoHcCnhKs3PYCbtLDdCvb3OHU=" defer=""></script><script src="https://static.intercomassets.com/_next/static/chunks/pages/%5BhelpCenterIdentifier%5D/%5Blocale%5D/articles/%5BarticleSlug%5D-f23178055b57ca92.js" nonce="isF+8Twgjhz0bOnKQEyoHcCnhKs3PYCbtLDdCvb3OHU=" defer=""></script><script src="https://static.intercomassets.com/_next/static/pBE9iWbiWcYTeTlBTemWk/_buildManifest.js" nonce="isF+8Twgjhz0bOnKQEyoHcCnhKs3PYCbtLDdCvb3OHU=" defer=""></script><script src="https://static.intercomassets.com/_next/static/pBE9iWbiWcYTeTlBTemWk/_ssgManifest.js" nonce="isF+8Twgjhz0bOnKQEyoHcCnhKs3PYCbtLDdCvb3OHU=" defer=""></script><meta name="sentry-trace" content="76701f79640544cc3c59245cf518f75a-beffdb4f746d5f5a-0"/><meta name="baggage" content="sentry-environment=production,sentry-release=pBE9iWbiWcYTeTlBTemWk,sentry-public_key=187f842308a64dea9f1f64d4b1b9c298,sentry-trace_id=76701f79640544cc3c59245cf518f75a,sentry-sampled=false"/><style id="__jsx-37099432">:root{--body-bg: rgb(255, 255, 255); --body-image: none; --body-bg-rgb: 255, 255, 255; --body-border: rgb(230, 230, 230); --body-primary-color: #1a1a1a; --body-secondary-color: #737373; --body-reaction-bg: rgb(242, 242, 242); --body-reaction-text-color: rgb(64, 64, 64); --body-toc-active-border: #737373; --body-toc-inactive-border: #f2f2f2; --body-toc-inactive-color: #737373; --body-toc-active-font-weight: 400; --body-table-border: rgb(204, 204, 204); --body-color: hsl(0, 0%, 0%); --footer-bg: rgb(255, 255, 255); --footer-image: none; --footer-border: rgb(230, 230, 230); --footer-color: hsl(256, 100%, 34%); --header-bg: rgb(45, 0, 173); --header-image: none; --header-color: hsl(0, 0%, 100%); --collection-card-bg: rgb(255, 255, 255); --collection-card-image: none; --collection-card-color: hsl(256, 100%, 34%); --card-bg: rgb(255, 255, 255); --card-border-color: rgb(230, 230, 230); --card-border-inner-radius: 6px; --card-border-radius: 8px; --card-shadow: 0 1px 2px 0 rgb(0 0 0 / 0.05); --search-bar-border-radius: 10px; --search-bar-width: 100%; --ticket-blue-bg-color: #dce1f9; --ticket-blue-text-color: #334bfa; --ticket-green-bg-color: #d7efdc; --ticket-green-text-color: #0f7134; --ticket-orange-bg-color: #ffebdb; --ticket-orange-text-color: #b24d00; --header-height: 245px; --header-subheader-background-color: #000000; --header-subheader-font-color: #FFFFFF; --content-block-bg: rgb(255, 255, 255); --content-block-image: none; --content-block-color: hsl(0, 0%, 10%); --content-block-button-bg: rgb(51, 75, 250); --content-block-button-image: none; --content-block-button-color: hsl(0, 0%, 100%); --content-block-button-radius: 6px; --primary-color: hsl(256, 100%, 34%); --primary-color-alpha-10: hsla(256, 100%, 34%, 0.1); --primary-color-alpha-60: hsla(256, 100%, 34%, 0.6); --text-on-primary-color: #ffffff}</style><style id="__jsx-2094555375">:root{--font-family-primary: system-ui, "Segoe UI", "Roboto", "Helvetica", "Arial", sans-serif, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol"}</style><style id="__jsx-2605255833">:root{--font-family-secondary: system-ui, "Segoe UI", "Roboto", "Helvetica", "Arial", sans-serif, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol"}</style><style id="__jsx-73269029ea53bf4f">.fade-background.jsx-73269029ea53bf4f{background:-webkit-radial-gradient(50%0%,333.38%100%,rgba(var(--body-bg-rgb),0)0%,rgba(var(--body-bg-rgb),.00925356)11.67%,rgba(var(--body-bg-rgb),.0337355)21.17%,rgba(var(--body-bg-rgb),.0718242)28.85%,rgba(var(--body-bg-rgb),.121898)35.03%,rgba(var(--body-bg-rgb),.182336)40.05%,rgba(var(--body-bg-rgb),.251516)44.25%,rgba(var(--body-bg-rgb),.327818)47.96%,rgba(var(--body-bg-rgb),.409618)51.51%,rgba(var(--body-bg-rgb),.495297)55.23%,rgba(var(--body-bg-rgb),.583232)59.47%,rgba(var(--body-bg-rgb),.671801)64.55%,rgba(var(--body-bg-rgb),.759385)70.81%,rgba(var(--body-bg-rgb),.84436)78.58%,rgba(var(--body-bg-rgb),.9551)88.2%,rgba(var(--body-bg-rgb),1)100%),var(--header-image),var(--header-bg);background:-moz-radial-gradient(50%0%,333.38%100%,rgba(var(--body-bg-rgb),0)0%,rgba(var(--body-bg-rgb),.00925356)11.67%,rgba(var(--body-bg-rgb),.0337355)21.17%,rgba(var(--body-bg-rgb),.0718242)28.85%,rgba(var(--body-bg-rgb),.121898)35.03%,rgba(var(--body-bg-rgb),.182336)40.05%,rgba(var(--body-bg-rgb),.251516)44.25%,rgba(var(--body-bg-rgb),.327818)47.96%,rgba(var(--body-bg-rgb),.409618)51.51%,rgba(var(--body-bg-rgb),.495297)55.23%,rgba(var(--body-bg-rgb),.583232)59.47%,rgba(var(--body-bg-rgb),.671801)64.55%,rgba(var(--body-bg-rgb),.759385)70.81%,rgba(var(--body-bg-rgb),.84436)78.58%,rgba(var(--body-bg-rgb),.9551)88.2%,rgba(var(--body-bg-rgb),1)100%),var(--header-image),var(--header-bg);background:-o-radial-gradient(50%0%,333.38%100%,rgba(var(--body-bg-rgb),0)0%,rgba(var(--body-bg-rgb),.00925356)11.67%,rgba(var(--body-bg-rgb),.0337355)21.17%,rgba(var(--body-bg-rgb),.0718242)28.85%,rgba(var(--body-bg-rgb),.121898)35.03%,rgba(var(--body-bg-rgb),.182336)40.05%,rgba(var(--body-bg-rgb),.251516)44.25%,rgba(var(--body-bg-rgb),.327818)47.96%,rgba(var(--body-bg-rgb),.409618)51.51%,rgba(var(--body-bg-rgb),.495297)55.23%,rgba(var(--body-bg-rgb),.583232)59.47%,rgba(var(--body-bg-rgb),.671801)64.55%,rgba(var(--body-bg-rgb),.759385)70.81%,rgba(var(--body-bg-rgb),.84436)78.58%,rgba(var(--body-bg-rgb),.9551)88.2%,rgba(var(--body-bg-rgb),1)100%),var(--header-image),var(--header-bg);background:radial-gradient(333.38%100%at 50%0%,rgba(var(--body-bg-rgb),0)0%,rgba(var(--body-bg-rgb),.00925356)11.67%,rgba(var(--body-bg-rgb),.0337355)21.17%,rgba(var(--body-bg-rgb),.0718242)28.85%,rgba(var(--body-bg-rgb),.121898)35.03%,rgba(var(--body-bg-rgb),.182336)40.05%,rgba(var(--body-bg-rgb),.251516)44.25%,rgba(var(--body-bg-rgb),.327818)47.96%,rgba(var(--body-bg-rgb),.409618)51.51%,rgba(var(--body-bg-rgb),.495297)55.23%,rgba(var(--body-bg-rgb),.583232)59.47%,rgba(var(--body-bg-rgb),.671801)64.55%,rgba(var(--body-bg-rgb),.759385)70.81%,rgba(var(--body-bg-rgb),.84436)78.58%,rgba(var(--body-bg-rgb),.9551)88.2%,rgba(var(--body-bg-rgb),1)100%),var(--header-image),var(--header-bg);-webkit-background-size:cover;-moz-background-size:cover;-o-background-size:cover;background-size:cover;background-position-x:center}</style><style id="__jsx-27f84a20f81f6ce9">.table-of-contents::-webkit-scrollbar{width:8px}.table-of-contents::-webkit-scrollbar-thumb{background-color:#f2f2f2;-webkit-border-radius:8px;-moz-border-radius:8px;border-radius:8px}</style><style id="__jsx-a49d9ef8a9865a27">.table_of_contents.jsx-a49d9ef8a9865a27{max-width:260px;min-width:260px}</style><style id="__jsx-62724fba150252e0">.related_articles section a{color:initial}</style><style id="__jsx-ef86202475c6562f">.article_body a{color:var(--primary-color)}article a.intercom-h2b-button{background-color:var(--primary-color);border:0}.zendesk-article table{overflow-x:scroll!important;display:block!important;height:auto!important}.intercom-interblocks-unordered-nested-list ul,.intercom-interblocks-ordered-nested-list ol{margin-top:16px;margin-bottom:16px}.intercom-interblocks-unordered-nested-list ul .intercom-interblocks-unordered-nested-list ul,.intercom-interblocks-unordered-nested-list ul .intercom-interblocks-ordered-nested-list ol,.intercom-interblocks-ordered-nested-list ol .intercom-interblocks-ordered-nested-list ol,.intercom-interblocks-ordered-nested-list ol .intercom-interblocks-unordered-nested-list ul{margin-top:0;margin-bottom:0}.intercom-interblocks-image a:focus{outline-offset:3px}</style></head><body><div id="__next"><div dir="ltr" class="h-full w-full"><a href="#main-content" class="sr-only">Skip to main content</a><main class="header__lite"><header id="header" data-testid="header" class="jsx-73269029ea53bf4f flex flex-col text-header-color"><div class="jsx-73269029ea53bf4f relative flex grow flex-col mb-9 bg-header-bg bg-header-image bg-cover bg-center pb-9"><div class="jsx-73269029ea53bf4f flex h-full flex-col items-center marker:shrink-0"><section class="relative flex w-full flex-col mb-6 pb-6"><div class="header__meta_wrapper flex justify-center px-5 pt-6 leading-none sm:px-10"><div class="flex items-center w-240" data-testid="subheader-container"><div class="mo__body header__site_name"><div class="header__logo"><a href="/en/"><img src="https://downloads.intercomcdn.com/i/o/555069/c46db78606979de5b10de666/1b738d52b69da9fed6134d1b044aa87d.png" height="144" alt="Productive Help Center"/></a></div></div><div><div class="flex items-center font-semibold"><div class="flex items-center md:hidden" data-testid="small-screen-children"><button class="flex items-center border-none bg-transparent px-1.5" data-testid="hamburger-menu-button" aria-label="Open menu"><svg width="24" height="24" viewBox="0 0 16 16" xmlns="http://www.w3.org/2000/svg" class="fill-current"><path d="M1.86861 2C1.38889 2 1 2.3806 1 2.85008C1 3.31957 1.38889 3.70017 1.86861 3.70017H14.1314C14.6111 3.70017 15 3.31957 15 2.85008C15 2.3806 14.6111 2 14.1314 2H1.86861Z"></path><path d="M1 8C1 7.53051 1.38889 7.14992 1.86861 7.14992H14.1314C14.6111 7.14992 15 7.53051 15 8C15 8.46949 14.6111 8.85008 14.1314 8.85008H1.86861C1.38889 8.85008 1 8.46949 1 8Z"></path><path d="M1 13.1499C1 12.6804 1.38889 12.2998 1.86861 12.2998H14.1314C14.6111 12.2998 15 12.6804 15 13.1499C15 13.6194 14.6111 14 14.1314 14H1.86861C1.38889 14 1 13.6194 1 13.1499Z"></path></svg></button><div class="fixed right-0 top-0 z-50 h-full w-full hidden" data-testid="hamburger-menu"><div class="flex h-full w-full justify-end bg-black bg-opacity-30"><div class="flex h-fit w-full flex-col bg-white opacity-100 sm:h-full sm:w-1/2"><button class="text-body-font flex items-center self-end border-none bg-transparent pr-6 pt-6" data-testid="hamburger-menu-close-button" aria-label="Close menu"><svg width="24" height="24" viewBox="0 0 16 16" xmlns="http://www.w3.org/2000/svg"><path d="M3.5097 3.5097C3.84165 3.17776 4.37984 3.17776 4.71178 3.5097L7.99983 6.79775L11.2879 3.5097C11.6198 3.17776 12.158 3.17776 12.49 3.5097C12.8219 3.84165 12.8219 4.37984 12.49 4.71178L9.20191 7.99983L12.49 11.2879C12.8219 11.6198 12.8219 12.158 12.49 12.49C12.158 12.8219 11.6198 12.8219 11.2879 12.49L7.99983 9.20191L4.71178 12.49C4.37984 12.8219 3.84165 12.8219 3.5097 12.49C3.17776 12.158 3.17776 11.6198 3.5097 11.2879L6.79775 7.99983L3.5097 4.71178C3.17776 4.37984 3.17776 3.84165 3.5097 3.5097Z"></path></svg></button><nav class="flex flex-col pl-4 text-black"><div class="relative cursor-pointer has-[:focus]:outline"><select class="peer absolute z-10 block h-6 w-full cursor-pointer opacity-0 md:text-base"><option value="/en/articles/3933649-formula-fields" class="text-black" selected="">English</option>;</select><div class="mb-10 ml-5 flex items-center gap-1 text-md hover:opacity-80 peer-hover:opacity-80 md:m-0 md:ml-3 md:text-base"><svg id="locale-picker-globe" width="16" height="16" viewBox="0 0 16 16" fill="none" xmlns="http://www.w3.org/2000/svg" class="shrink-0" aria-hidden="true"><path d="M8 15C11.866 15 15 11.866 15 8C15 4.13401 11.866 1 8 1C4.13401 1 1 4.13401 1 8C1 11.866 4.13401 15 8 15Z" stroke="currentColor" stroke-linecap="round" stroke-linejoin="round"></path><path d="M8 15C9.39949 15 10.534 11.866 10.534 8C10.534 4.13401 9.39949 1 8 1C6.60051 1 5.466 4.13401 5.466 8C5.466 11.866 6.60051 15 8 15Z" stroke="currentColor" stroke-linecap="round" stroke-linejoin="round"></path><path d="M1.448 5.75989H14.524" stroke="currentColor" stroke-linecap="round" stroke-linejoin="round"></path><path d="M1.448 10.2402H14.524" stroke="currentColor" stroke-linecap="round" stroke-linejoin="round"></path></svg>English<svg id="locale-picker-arrow" width="16" height="16" viewBox="0 0 16 16" fill="none" xmlns="http://www.w3.org/2000/svg" class="shrink-0" aria-label="Change language" role="button"><path d="M5 6.5L8.00093 9.5L11 6.50187" stroke="currentColor" stroke-width="1.5" stroke-linecap="round" stroke-linejoin="round" aria-hidden="true"></path></svg></div></div></nav></div></div></div></div><nav class="hidden items-center md:flex" data-testid="large-screen-children"><div class="relative cursor-pointer has-[:focus]:outline"><select class="peer absolute z-10 block h-6 w-full cursor-pointer opacity-0 md:text-base"><option value="/en/articles/3933649-formula-fields" class="text-black" selected="">English</option>;</select><div class="mb-10 ml-5 flex items-center gap-1 text-md hover:opacity-80 peer-hover:opacity-80 md:m-0 md:ml-3 md:text-base"><svg id="locale-picker-globe" width="16" height="16" viewBox="0 0 16 16" fill="none" xmlns="http://www.w3.org/2000/svg" class="shrink-0" aria-hidden="true"><path d="M8 15C11.866 15 15 11.866 15 8C15 4.13401 11.866 1 8 1C4.13401 1 1 4.13401 1 8C1 11.866 4.13401 15 8 15Z" stroke="currentColor" stroke-linecap="round" stroke-linejoin="round"></path><path d="M8 15C9.39949 15 10.534 11.866 10.534 8C10.534 4.13401 9.39949 1 8 1C6.60051 1 5.466 4.13401 5.466 8C5.466 11.866 6.60051 15 8 15Z" stroke="currentColor" stroke-linecap="round" stroke-linejoin="round"></path><path d="M1.448 5.75989H14.524" stroke="currentColor" stroke-linecap="round" stroke-linejoin="round"></path><path d="M1.448 10.2402H14.524" stroke="currentColor" stroke-linecap="round" stroke-linejoin="round"></path></svg>English<svg id="locale-picker-arrow" width="16" height="16" viewBox="0 0 16 16" fill="none" xmlns="http://www.w3.org/2000/svg" class="shrink-0" aria-label="Change language" role="button"><path d="M5 6.5L8.00093 9.5L11 6.50187" stroke="currentColor" stroke-width="1.5" stroke-linecap="round" stroke-linejoin="round" aria-hidden="true"></path></svg></div></div></nav></div></div></div></div></section><section class="relative mx-5 flex h-full w-full flex-col items-center px-5 sm:px-10"><div class="flex h-full max-w-full flex-col w-240 justify-end" data-testid="main-header-container"><div id="search-bar" class="relative w-full"><form action="/en/" autoComplete="off"><div class="flex w-full flex-col items-start"><div class="relative flex w-full sm:w-search-bar"><input type="text" autoComplete="off" class="peer w-full rounded-search-bar border border-black-alpha-8 bg-white-alpha-20 p-4 ps-12 font-secondary text-lg text-header-color shadow-search-bar outline-none transition ease-linear placeholder:text-header-color hover:bg-white-alpha-27 hover:shadow-search-bar-hover focus:border-transparent focus:bg-white focus:text-black-10 focus:shadow-search-bar-focused placeholder:focus:text-black-45" placeholder="Search for articles..." name="q" value=""/><div class="pointer-events-none absolute inset-y-0 start-0 flex items-center fill-header-color ps-5 peer-focus-visible:fill-black-45"><svg width="22" height="21" viewBox="0 0 22 21" xmlns="http://www.w3.org/2000/svg" class="fill-inherit" aria-hidden="true"><path fill-rule="evenodd" clip-rule="evenodd" d="M3.27485 8.7001C3.27485 5.42781 5.92757 2.7751 9.19985 2.7751C12.4721 2.7751 15.1249 5.42781 15.1249 8.7001C15.1249 11.9724 12.4721 14.6251 9.19985 14.6251C5.92757 14.6251 3.27485 11.9724 3.27485 8.7001ZM9.19985 0.225098C4.51924 0.225098 0.724854 4.01948 0.724854 8.7001C0.724854 13.3807 4.51924 17.1751 9.19985 17.1751C11.0802 17.1751 12.8176 16.5627 14.2234 15.5265L19.0981 20.4013C19.5961 20.8992 20.4033 20.8992 20.9013 20.4013C21.3992 19.9033 21.3992 19.0961 20.9013 18.5981L16.0264 13.7233C17.0625 12.3176 17.6749 10.5804 17.6749 8.7001C17.6749 4.01948 13.8805 0.225098 9.19985 0.225098Z"></path></svg></div></div></div></form></div></div></section></div></div></header><div class="z-1 flex shrink-0 grow basis-auto justify-center px-5 sm:px-10"><section data-testid="main-content" id="main-content" class="max-w-full w-240"><section data-testid="article-section" class="section section__article"><div class="flex-row-reverse justify-between flex"><div class="jsx-a49d9ef8a9865a27 w-61 sticky top-8 ml-7 max-w-61 self-start max-lg:hidden mt-16"><div class="jsx-27f84a20f81f6ce9 table-of-contents max-h-[calc(100vh-96px)] overflow-y-auto rounded-2xl text-body-primary-color hover:text-primary max-lg:border max-lg:border-solid max-lg:border-body-border max-lg:shadow-solid-1"><div data-testid="toc-dropdown" class="jsx-27f84a20f81f6ce9 hidden cursor-pointer justify-between border-b max-lg:flex max-lg:flex-row max-lg:border-x-0 max-lg:border-t-0 max-lg:border-solid max-lg:border-b-body-border"><div class="jsx-27f84a20f81f6ce9 my-2 max-lg:pl-4">Table of contents</div><div class="jsx-27f84a20f81f6ce9 "><svg class="ml-2 mr-4 mt-3 transition-transform" transform="rotate(180)" width="16" height="16" fill="none" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" clip-rule="evenodd" d="M3.93353 5.93451C4.24595 5.62209 4.75248 5.62209 5.0649 5.93451L7.99922 8.86882L10.9335 5.93451C11.246 5.62209 11.7525 5.62209 12.0649 5.93451C12.3773 6.24693 12.3773 6.75346 12.0649 7.06588L8.5649 10.5659C8.25249 10.8783 7.74595 10.8783 7.43353 10.5659L3.93353 7.06588C3.62111 6.75346 3.62111 6.24693 3.93353 5.93451Z" fill="currentColor"></path></svg></div></div><div data-testid="toc-body" class="jsx-27f84a20f81f6ce9 my-2"><section data-testid="toc-section-0" class="jsx-27f84a20f81f6ce9 flex border-y-0 border-e-0 border-s-2 border-solid py-1.5 max-lg:border-none border-body-toc-active-border px-4"><a id="#h_0f2d30172f" href="#h_0f2d30172f" data-testid="toc-link-0" class="jsx-27f84a20f81f6ce9 w-full no-underline hover:text-body-primary-color max-lg:inline-block max-lg:text-body-primary-color max-lg:hover:text-primary lg:text-base font-toc-active text-body-primary-color"></a></section><section data-testid="toc-section-1" class="jsx-27f84a20f81f6ce9 flex border-y-0 border-e-0 border-s-2 border-solid py-1.5 max-lg:border-none px-4"><a id="#h_f94d7eb333" href="#h_f94d7eb333" data-testid="toc-link-1" class="jsx-27f84a20f81f6ce9 w-full no-underline hover:text-body-primary-color max-lg:inline-block max-lg:text-body-primary-color max-lg:hover:text-primary lg:text-base text-body-toc-inactive-color"></a></section></div></div></div><div class="relative z-3 w-full lg:max-w-160 "><div class="flex pb-6 max-md:pb-2 lg:max-w-160"><div class="flex flex-wrap items-baseline pb-4 text-base"><a href="/en/" class="pr-2 text-body-primary-color no-underline hover:text-body-secondary-color">All Collections</a><div class="pr-2" aria-hidden="true"><svg width="6" height="10" viewBox="0 0 6 10" class="block h-2 w-2 fill-body-secondary-color rtl:rotate-180" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" clip-rule="evenodd" d="M0.648862 0.898862C0.316916 1.23081 0.316916 1.769 0.648862 2.10094L3.54782 4.9999L0.648862 7.89886C0.316916 8.23081 0.316917 8.769 0.648862 9.10094C0.980808 9.43289 1.519 9.43289 1.85094 9.10094L5.35094 5.60094C5.68289 5.269 5.68289 4.73081 5.35094 4.39886L1.85094 0.898862C1.519 0.566916 0.980807 0.566916 0.648862 0.898862Z"></path></svg></div><a href="https://help.productive.io/en/collections/9262206-data-management-and-pdf-customization" class="pr-2 text-body-primary-color no-underline hover:text-body-secondary-color" data-testid="breadcrumb-0">Data Management and PDF Customization</a><div class="pr-2" aria-hidden="true"><svg width="6" height="10" viewBox="0 0 6 10" class="block h-2 w-2 fill-body-secondary-color rtl:rotate-180" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" clip-rule="evenodd" d="M0.648862 0.898862C0.316916 1.23081 0.316916 1.769 0.648862 2.10094L3.54782 4.9999L0.648862 7.89886C0.316916 8.23081 0.316917 8.769 0.648862 9.10094C0.980808 9.43289 1.519 9.43289 1.85094 9.10094L5.35094 5.60094C5.68289 5.269 5.68289 4.73081 5.35094 4.39886L1.85094 0.898862C1.519 0.566916 0.980807 0.566916 0.648862 0.898862Z"></path></svg></div><a href="https://help.productive.io/en/collections/10042407-data-management" class="pr-2 text-body-primary-color no-underline hover:text-body-secondary-color" data-testid="breadcrumb-1">Data Management</a><div class="pr-2" aria-hidden="true"><svg width="6" height="10" viewBox="0 0 6 10" class="block h-2 w-2 fill-body-secondary-color rtl:rotate-180" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" clip-rule="evenodd" d="M0.648862 0.898862C0.316916 1.23081 0.316916 1.769 0.648862 2.10094L3.54782 4.9999L0.648862 7.89886C0.316916 8.23081 0.316917 8.769 0.648862 9.10094C0.980808 9.43289 1.519 9.43289 1.85094 9.10094L5.35094 5.60094C5.68289 5.269 5.68289 4.73081 5.35094 4.39886L1.85094 0.898862C1.519 0.566916 0.980807 0.566916 0.648862 0.898862Z"></path></svg></div><div class="text-body-secondary-color">Formula Fields</div></div></div><div class=""><div class="article intercom-force-break"><div class="mb-10 max-lg:mb-6"><div class="flex flex-col gap-4"><div class="flex flex-col"><header class="mb-1 font-primary text-2xl font-bold leading-10 text-body-primary-color">Formula Fields</header><div class="text-md font-normal leading-normal text-body-secondary-color"><p>Learn how to create, add, and use custom formula fields in Productive.</p></div></div><div class="avatar"><div class="avatar__info -mt-0.5 text-base"><span class="text-body-secondary-color"> Updated over 4 months ago</span></div></div></div></div><div class="jsx-ef86202475c6562f flex-col"><div class="jsx-ef86202475c6562f mb-7 ml-0 text-md max-messenger:mb-6 lg:hidden"><div class="jsx-27f84a20f81f6ce9 table-of-contents max-h-[calc(100vh-96px)] overflow-y-auto rounded-2xl text-body-primary-color hover:text-primary max-lg:border max-lg:border-solid max-lg:border-body-border max-lg:shadow-solid-1"><div data-testid="toc-dropdown" class="jsx-27f84a20f81f6ce9 hidden cursor-pointer justify-between border-b max-lg:flex max-lg:flex-row max-lg:border-x-0 max-lg:border-t-0 max-lg:border-solid max-lg:border-b-body-border border-b-0"><div class="jsx-27f84a20f81f6ce9 my-2 max-lg:pl-4">Table of contents</div><div class="jsx-27f84a20f81f6ce9 "><svg class="ml-2 mr-4 mt-3 transition-transform" transform="" width="16" height="16" fill="none" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" clip-rule="evenodd" d="M3.93353 5.93451C4.24595 5.62209 4.75248 5.62209 5.0649 5.93451L7.99922 8.86882L10.9335 5.93451C11.246 5.62209 11.7525 5.62209 12.0649 5.93451C12.3773 6.24693 12.3773 6.75346 12.0649 7.06588L8.5649 10.5659C8.25249 10.8783 7.74595 10.8783 7.43353 10.5659L3.93353 7.06588C3.62111 6.75346 3.62111 6.24693 3.93353 5.93451Z" fill="currentColor"></path></svg></div></div><div data-testid="toc-body" class="jsx-27f84a20f81f6ce9 hidden my-2"><section data-testid="toc-section-0" class="jsx-27f84a20f81f6ce9 flex border-y-0 border-e-0 border-s-2 border-solid py-1.5 max-lg:border-none border-body-toc-active-border px-4"><a id="#h_0f2d30172f" href="#h_0f2d30172f" data-testid="toc-link-0" class="jsx-27f84a20f81f6ce9 w-full no-underline hover:text-body-primary-color max-lg:inline-block max-lg:text-body-primary-color max-lg:hover:text-primary lg:text-base font-toc-active text-body-primary-color"></a></section><section data-testid="toc-section-1" class="jsx-27f84a20f81f6ce9 flex border-y-0 border-e-0 border-s-2 border-solid py-1.5 max-lg:border-none px-4"><a id="#h_f94d7eb333" href="#h_f94d7eb333" data-testid="toc-link-1" class="jsx-27f84a20f81f6ce9 w-full no-underline hover:text-body-primary-color max-lg:inline-block max-lg:text-body-primary-color max-lg:hover:text-primary lg:text-base text-body-toc-inactive-color"></a></section></div></div></div><div class="jsx-ef86202475c6562f article_body"><article class="jsx-ef86202475c6562f "><div class="intercom-interblocks-paragraph no-margin intercom-interblocks-align-left"><p>In Productive, there is a field for just about everything, but sometimes you have your unique metric or calculation that isn't available by default. </p></div><div class="intercom-interblocks-paragraph no-margin intercom-interblocks-align-left"><p> </p></div><div class="intercom-interblocks-paragraph no-margin intercom-interblocks-align-left"><p>Luckily, you can use formulas to combine multiple fields into a custom formula field with simple mathematical operations. Note that formula fields are available for all numeric data across Productive!<br/></p></div><div class="intercom-interblocks-paragraph no-margin intercom-interblocks-align-left"><p>To add your formula field, click on <b>Fields</b> > <b>Add Formula</b>.</p></div><div class="intercom-interblocks-paragraph no-margin intercom-interblocks-align-left"><p> </p></div><div class="intercom-interblocks-image intercom-interblocks-align-left"><a href="https://downloads.intercomcdn.com/i/o/957271338/285423ca4aafa1cc47c24c3b/Screenshot+2024-02-08+at+13.59.05.png?expires=1732751100&signature=905d746778905f3240c726703b5c6653533e9ee96ad052f6b090892b5c400a5f&req=fSUgFM5%2FnoJXFb4f3HP0gPXFBfruYMZiVDep7%2FPH9RUoye%2FFCKDA3ha%2BJEuf%0Amw9WjqaPYfZ8wMUgDQ%3D%3D%0A" target="_blank" rel="noreferrer nofollow noopener"><img src="https://downloads.intercomcdn.com/i/o/957271338/285423ca4aafa1cc47c24c3b/Screenshot+2024-02-08+at+13.59.05.png?expires=1732751100&signature=905d746778905f3240c726703b5c6653533e9ee96ad052f6b090892b5c400a5f&req=fSUgFM5%2FnoJXFb4f3HP0gPXFBfruYMZiVDep7%2FPH9RUoye%2FFCKDA3ha%2BJEuf%0Amw9WjqaPYfZ8wMUgDQ%3D%3D%0A" width="2552" height="1358"/></a></div><div class="intercom-interblocks-paragraph no-margin intercom-interblocks-align-left"><p> </p></div><div class="intercom-interblocks-image intercom-interblocks-align-center"><a href="https://downloads.intercomcdn.com/i/o/957296534/d57fab281e28d353f48a9d1f/Screenshot+2024-02-08+at+14.24.11.png?expires=1732751100&signature=a32ed749ab00aad2a0c1ef000b8c9943e6970298340af38d25643dbc4df9b222&req=fSUgFMB4mIJbFb4f3HP0gAG0LFiEIGFrSS38dCJjiG%2F88OV9d%2BkvAgNq8UP4%0AzBuCUQWckpF7c6b%2BAQ%3D%3D%0A" target="_blank" rel="noreferrer nofollow noopener"><img src="https://downloads.intercomcdn.com/i/o/957296534/d57fab281e28d353f48a9d1f/Screenshot+2024-02-08+at+14.24.11.png?expires=1732751100&signature=a32ed749ab00aad2a0c1ef000b8c9943e6970298340af38d25643dbc4df9b222&req=fSUgFMB4mIJbFb4f3HP0gAG0LFiEIGFrSS38dCJjiG%2F88OV9d%2BkvAgNq8UP4%0AzBuCUQWckpF7c6b%2BAQ%3D%3D%0A" width="1426" height="1190" style="width:450px"/></a></div><div class="intercom-interblocks-heading intercom-interblocks-align-left"><h1 id="h_0f2d30172f"><br/>Creating a new custom formula</h1></div><div class="intercom-interblocks-paragraph no-margin intercom-interblocks-align-left"><p>1) Begin by assigning a name to your new field.</p></div><div class="intercom-interblocks-paragraph no-margin intercom-interblocks-align-left"><p> </p></div><div class="intercom-interblocks-paragraph no-margin intercom-interblocks-align-left"><p>2) Choose the values you wish to incorporate. Start by typing "@" to display a dropdown menu with available options. Combine these values using the following supported operations: </p></div><div class="intercom-interblocks-unordered-nested-list"><ul><li><div class="intercom-interblocks-paragraph no-margin intercom-interblocks-align-left"><p>Addition (+)</p></div></li><li><div class="intercom-interblocks-paragraph no-margin intercom-interblocks-align-left"><p>Subtraction (-)</p></div></li><li><div class="intercom-interblocks-paragraph no-margin intercom-interblocks-align-left"><p>Multiplication (*)</p></div></li><li><div class="intercom-interblocks-paragraph no-margin intercom-interblocks-align-left"><p>Division (/)</p></div></li><li><div class="intercom-interblocks-paragraph no-margin intercom-interblocks-align-left"><p>Formulas can also be enclosed in brackets for clarity: (A - B) * C.</p></div></li></ul></div><div class="intercom-interblocks-paragraph no-margin intercom-interblocks-align-left"><p> </p></div><div class="intercom-interblocks-heading intercom-interblocks-align-left"><h1 id="h_f94d7eb333">Number formats in Productive </h1></div><div class="intercom-interblocks-paragraph no-margin intercom-interblocks-align-left"><p>When inputting values in custom formulas, it's important to note that <b>money values are counted in cents</b>, while <b>time values are counted in minutes</b>. This ensures accurate calculations and prevents any misunderstandings with the units being used.<br/></p></div><div class="intercom-interblocks-unordered-nested-list"><ul><li><div class="intercom-interblocks-paragraph no-margin intercom-interblocks-align-left"><p>If you are adding a custom formula which will be <b>taking into account money values</b>, the inserted value will be counted in cents.<br/><br/>For example, if you write "<b>100</b>", the calculated value will be 1.00, so make sure to add two zeroes if needed. In other words, instead of 100 becoming 1.00, you will need to enter 10000 which will become 100.00.<br/></p></div></li></ul></div><div class="intercom-interblocks-unordered-nested-list"><ul><li><div class="intercom-interblocks-paragraph no-margin intercom-interblocks-align-left"><p>If you are adding a custom formula which will be <b>taking into account time values</b>, the inserted value will be counted in minutes. <br/><br/>In other words, if you write "100", the calculated value will be 100 minutes, not hours.<br/></p></div></li></ul></div><div class="intercom-interblocks-callout" style="background-color:#e3e7fa80;border-color:#334bfa33"><div class="intercom-interblocks-paragraph no-margin intercom-interblocks-align-left"><p><b>Custom Formula Use Case</b><br/><br/>Let's generate a field to showcase the difference between the time we estimated it would take to finish a project and the time we worked and logged in Productive. <br/><br/>The formula we want to use here is Estimated time - Worked time. We'll call our new field "Remaining time" for simplicity.<br/><br/>After inputting the formula, click on "Create Field" to add it to your view.</p></div><div class="intercom-interblocks-paragraph no-margin intercom-interblocks-align-left"><p> </p></div><div class="intercom-interblocks-image intercom-interblocks-align-center"><a href="https://downloads.intercomcdn.com/i/o/410929917/69f9a0e6fff38514eea4a0e5/Slika+zaslona+2021-10-29+u+10.55.32.png?expires=1732751100&signature=2a276ea86c176666e597a6235c9cf76dec5b1c6495b84083151bd7a2427e6fee&req=cCEnH8t3lIBYFb4f3HP0gJey0NYpxKZ2hWokrfC9sPrMOrSsD9ETWGNl5FpK%0ATpKtCQKbr45fX3VIgA%3D%3D%0A" target="_blank" rel="noreferrer nofollow noopener"><img src="https://downloads.intercomcdn.com/i/o/410929917/69f9a0e6fff38514eea4a0e5/Slika+zaslona+2021-10-29+u+10.55.32.png?expires=1732751100&signature=2a276ea86c176666e597a6235c9cf76dec5b1c6495b84083151bd7a2427e6fee&req=cCEnH8t3lIBYFb4f3HP0gJey0NYpxKZ2hWokrfC9sPrMOrSsD9ETWGNl5FpK%0ATpKtCQKbr45fX3VIgA%3D%3D%0A" width="1316" height="1000" style="width:500px"/></a></div><div class="intercom-interblocks-paragraph no-margin intercom-interblocks-align-left"><p> </p></div><div class="intercom-interblocks-image intercom-interblocks-align-center"><a href="https://downloads.intercomcdn.com/i/o/412224247/f5fa2696b43d6612d4da9165/Screenshot+2021-11-01+at+17.51.20.png?expires=1732751100&signature=c2197f672663a67143165a4237a565b58020f09ef8da807a2fcaaa3709073535&req=cCElFMt6n4VYFb4f3HP0gL08oBZ5Sr2%2FWrlqTQk2rtLuQiPspGJRrDnGdVaO%0AyGyUyR4rT033PT%2FqIA%3D%3D%0A" target="_blank" rel="noreferrer nofollow noopener"><img src="https://downloads.intercomcdn.com/i/o/412224247/f5fa2696b43d6612d4da9165/Screenshot+2021-11-01+at+17.51.20.png?expires=1732751100&signature=c2197f672663a67143165a4237a565b58020f09ef8da807a2fcaaa3709073535&req=cCElFMt6n4VYFb4f3HP0gL08oBZ5Sr2%2FWrlqTQk2rtLuQiPspGJRrDnGdVaO%0AyGyUyR4rT033PT%2FqIA%3D%3D%0A" width="1774" height="1002" style="width:470px"/></a></div></div><div class="intercom-interblocks-paragraph no-margin intercom-interblocks-align-left"><p> </p></div><div class="intercom-interblocks-callout" style="background-color:#e8e8e880;border-color:#73737633"><div class="intercom-interblocks-paragraph no-margin intercom-interblocks-align-left"><p><b>Pro tip: Composite Formulas</b></p></div><div class="intercom-interblocks-paragraph no-margin intercom-interblocks-align-left"><p> </p></div><div class="intercom-interblocks-paragraph no-margin intercom-interblocks-align-left"><p>In Productive, you can create composite formulas/fields by combining multiple formulas to calculate a single metric. </p></div><div class="intercom-interblocks-paragraph no-margin intercom-interblocks-align-left"><p> </p></div><div class="intercom-interblocks-paragraph no-margin intercom-interblocks-align-left"><p>For example, you can create the "Total Time" field, which is composed of two previously defined formulas "Internal" and "Client".</p></div><div class="intercom-interblocks-paragraph no-margin intercom-interblocks-align-left"><p> </p></div><div class="intercom-interblocks-paragraph no-margin intercom-interblocks-align-left"><p> </p></div><div class="intercom-interblocks-image intercom-interblocks-align-center"><a href="https://downloads.intercomcdn.com/i/o/957292236/a6644233ba4722ceca78ef19/Screenshot+2024-02-08+at+14.19.48.png?expires=1732751100&signature=a485973d4959367d22d275efcadcf5eb7cb589ffc569c6de79bb1c13abd0e211&req=fSUgFMB8n4JZFb4f3HP0gMpu5oUnx4P5ATY7zfomsyyOgMqyKxTdpiTBBjhb%0Akprccn9jy%2BCvuYoQjQ%3D%3D%0A" target="_blank" rel="noreferrer nofollow noopener"><img src="https://downloads.intercomcdn.com/i/o/957292236/a6644233ba4722ceca78ef19/Screenshot+2024-02-08+at+14.19.48.png?expires=1732751100&signature=a485973d4959367d22d275efcadcf5eb7cb589ffc569c6de79bb1c13abd0e211&req=fSUgFMB8n4JZFb4f3HP0gMpu5oUnx4P5ATY7zfomsyyOgMqyKxTdpiTBBjhb%0Akprccn9jy%2BCvuYoQjQ%3D%3D%0A" width="2508" height="1574" style="width:500px"/></a></div></div><section class="jsx-62724fba150252e0 related_articles my-6"><hr class="jsx-62724fba150252e0 my-6 sm:my-8"/><div class="jsx-62724fba150252e0 mb-3 text-xl font-bold">Related Articles</div><section class="flex flex-col rounded-card border border-solid border-card-border bg-card-bg p-2 sm:p-3"><a class="duration-250 group/article flex flex-row justify-between gap-2 py-2 no-underline transition ease-linear hover:bg-primary-alpha-10 hover:text-primary sm:rounded-card-inner sm:py-3 rounded-card-inner px-3" href="https://help.productive.io/en/articles/3732248-creating-and-adding-custom-fields" data-testid="article-link"><div class="flex flex-col p-0"><span class="m-0 text-md text-body-primary-color group-hover/article:text-primary">Creating and Adding Custom Fields</span></div><div class="flex shrink-0 flex-col justify-center p-0"><svg class="block h-4 w-4 text-primary ltr:-rotate-90 rtl:rotate-90" fill="currentColor" viewBox="0 0 20 20" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" d="M5.293 7.293a1 1 0 011.414 0L10 10.586l3.293-3.293a1 1 0 111.414 1.414l-4 4a1 1 0 01-1.414 0l-4-4a1 1 0 010-1.414z" clip-rule="evenodd"></path></svg></div></a><a class="duration-250 group/article flex flex-row justify-between gap-2 py-2 no-underline transition ease-linear hover:bg-primary-alpha-10 hover:text-primary sm:rounded-card-inner sm:py-3 rounded-card-inner px-3" href="https://help.productive.io/en/articles/4167962-task-custom-fields" data-testid="article-link"><div class="flex flex-col p-0"><span class="m-0 text-md text-body-primary-color group-hover/article:text-primary">Task Custom Fields</span></div><div class="flex shrink-0 flex-col justify-center p-0"><svg class="block h-4 w-4 text-primary ltr:-rotate-90 rtl:rotate-90" fill="currentColor" viewBox="0 0 20 20" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" d="M5.293 7.293a1 1 0 011.414 0L10 10.586l3.293-3.293a1 1 0 111.414 1.414l-4 4a1 1 0 01-1.414 0l-4-4a1 1 0 010-1.414z" clip-rule="evenodd"></path></svg></div></a><a class="duration-250 group/article flex flex-row justify-between gap-2 py-2 no-underline transition ease-linear hover:bg-primary-alpha-10 hover:text-primary sm:rounded-card-inner sm:py-3 rounded-card-inner px-3" href="https://help.productive.io/en/articles/9557085-number-custom-field" data-testid="article-link"><div class="flex flex-col p-0"><span class="m-0 text-md text-body-primary-color group-hover/article:text-primary">Number Custom Field</span></div><div class="flex shrink-0 flex-col justify-center p-0"><svg class="block h-4 w-4 text-primary ltr:-rotate-90 rtl:rotate-90" fill="currentColor" viewBox="0 0 20 20" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" d="M5.293 7.293a1 1 0 011.414 0L10 10.586l3.293-3.293a1 1 0 111.414 1.414l-4 4a1 1 0 01-1.414 0l-4-4a1 1 0 010-1.414z" clip-rule="evenodd"></path></svg></div></a><a class="duration-250 group/article flex flex-row justify-between gap-2 py-2 no-underline transition ease-linear hover:bg-primary-alpha-10 hover:text-primary sm:rounded-card-inner sm:py-3 rounded-card-inner px-3" href="https://help.productive.io/en/articles/9805366-setting-up-utilization-targets" data-testid="article-link"><div class="flex flex-col p-0"><span class="m-0 text-md text-body-primary-color group-hover/article:text-primary">Setting Up Utilization Targets</span></div><div class="flex shrink-0 flex-col justify-center p-0"><svg class="block h-4 w-4 text-primary ltr:-rotate-90 rtl:rotate-90" fill="currentColor" viewBox="0 0 20 20" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" d="M5.293 7.293a1 1 0 011.414 0L10 10.586l3.293-3.293a1 1 0 111.414 1.414l-4 4a1 1 0 01-1.414 0l-4-4a1 1 0 010-1.414z" clip-rule="evenodd"></path></svg></div></a><a class="duration-250 group/article flex flex-row justify-between gap-2 py-2 no-underline transition ease-linear hover:bg-primary-alpha-10 hover:text-primary sm:rounded-card-inner sm:py-3 rounded-card-inner px-3" href="https://help.productive.io/en/articles/10091471-automations-set-custom-field-values-for-tasks" data-testid="article-link"><div class="flex flex-col p-0"><span class="m-0 text-md text-body-primary-color group-hover/article:text-primary">Automations: Set Custom Field Values for Tasks</span></div><div class="flex shrink-0 flex-col justify-center p-0"><svg class="block h-4 w-4 text-primary ltr:-rotate-90 rtl:rotate-90" fill="currentColor" viewBox="0 0 20 20" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" d="M5.293 7.293a1 1 0 011.414 0L10 10.586l3.293-3.293a1 1 0 111.414 1.414l-4 4a1 1 0 01-1.414 0l-4-4a1 1 0 010-1.414z" clip-rule="evenodd"></path></svg></div></a></section></section></article></div></div></div></div><div class="intercom-reaction-picker -mb-4 -ml-4 -mr-4 mt-6 rounded-card sm:-mb-2 sm:-ml-1 sm:-mr-1 sm:mt-8"><div class="intercom-reaction-prompt">Did this answer your question?</div><button class="intercom-reaction" aria-label="Disappointed Reaction" tabindex="0" data-reaction-text="disappointed" aria-pressed="false"><span title="Disappointed">😞</span></button><button class="intercom-reaction" aria-label="Neutral Reaction" tabindex="0" data-reaction-text="neutral" aria-pressed="false"><span title="Neutral">😐</span></button><button class="intercom-reaction" aria-label="Smiley Reaction" tabindex="0" data-reaction-text="smiley" aria-pressed="false"><span title="Smiley">😃</span></button></div></div></div></section></section></div><footer id="footer" class="mt-24 shrink-0 bg-footer-bg px-0 py-12 text-left text-base text-footer-color"><div class="shrink-0 grow basis-auto px-5 sm:px-10"><div class="mx-auto max-w-240 sm:w-auto"><div><div class="text-center" data-testid="simple-footer-layout"><div class="align-middle text-lg text-footer-color"><a class="no-underline" href="/en/"><img data-testid="logo-img" src="https://downloads.intercomcdn.com/i/o/295088/7d1e9e7d334295930dd163a3/801f1c6d85d7662e8810fa8dcc02754d.png" alt="Productive Help Center" class="max-h-8 contrast-80 inline"/></a></div><div class="mt-10" data-testid="simple-footer-links"><div class="flex flex-row justify-center"></div><ul data-testid="social-links" class="flex flex-wrap items-center gap-4 p-0 justify-center" id="social-links"><li class="list-none align-middle"><a target="_blank" href="https://www.facebook.com/productiveio" rel="nofollow noreferrer noopener" data-testid="footer-social-link-0" class="no-underline"><img src="https://intercom.help/productive/assets/svg/icon:social-facebook/2D00AD" alt="" width="16" height="16" loading="lazy" data-testid="social-icon-facebook"/></a></li><li class="list-none align-middle"><a target="_blank" href="https://www.twitter.com/productiveio" rel="nofollow noreferrer noopener" data-testid="footer-social-link-1" class="no-underline"><img src="https://intercom.help/productive/assets/svg/icon:social-twitter/2D00AD" alt="" width="16" height="16" loading="lazy" data-testid="social-icon-twitter"/></a></li><li class="list-none align-middle"><a target="_blank" href="https://www.linkedin.com/company/productive-io/" rel="nofollow noreferrer noopener" data-testid="footer-social-link-2" class="no-underline"><img src="https://intercom.help/productive/assets/svg/icon:social-linkedin/2D00AD" alt="" width="16" height="16" loading="lazy" data-testid="social-icon-linkedin"/></a></li></ul></div></div></div></div></div></footer></main></div></div><script id="__NEXT_DATA__" type="application/json" nonce="isF+8Twgjhz0bOnKQEyoHcCnhKs3PYCbtLDdCvb3OHU=">{"props":{"pageProps":{"app":{"id":"fb4269c7d05ac700cbaddefb7bd5862f69a2b21b","messengerUrl":"https://widget.intercom.io/widget/fb4269c7d05ac700cbaddefb7bd5862f69a2b21b","name":"Productive","poweredByIntercomUrl":"https://www.intercom.com/intercom-link?company=Productive\u0026solution=customer-support\u0026utm_campaign=intercom-link\u0026utm_content=We+run+on+Intercom\u0026utm_medium=help-center\u0026utm_referrer=http%3A%2F%2Fhelp.productive.io%2Fen%2Farticles%2F3933649-formula-fields\u0026utm_source=desktop-web","features":{"customNotFoundErrorMessage":false}},"helpCenterSite":{"customDomain":"help.productive.io","defaultLocale":"en","disableBranding":true,"externalLoginName":null,"externalLoginUrl":null,"footerContactDetails":null,"footerLinks":{"custom":[],"socialLinks":[{"iconUrl":"https://intercom.help/productive/assets/svg/icon:social-facebook","provider":"facebook","url":"https://www.facebook.com/productiveio"},{"iconUrl":"https://intercom.help/productive/assets/svg/icon:social-twitter","provider":"twitter","url":"https://www.twitter.com/productiveio"},{"iconUrl":"https://intercom.help/productive/assets/svg/icon:social-linkedin","provider":"linkedin","url":"https://www.linkedin.com/company/productive-io/"}],"linkGroups":[]},"headerLinks":[],"homeCollectionCols":2,"googleAnalyticsTrackingId":"UA-113158496-2","googleTagManagerId":null,"pathPrefixForCustomDomain":null,"seoIndexingEnabled":true,"helpCenterId":31293,"url":"https://help.productive.io","customizedFooterTextContent":null},"localeLinks":[{"id":"en","absoluteUrl":"https://help.productive.io/en/articles/3933649-formula-fields","available":true,"name":"English","selected":true,"url":"/en/articles/3933649-formula-fields"}],"requestContext":{"articleSource":null,"canonicalUrl":"https://help.productive.io/en/articles/3933649-formula-fields","headerless":false,"isDefaultDomainRequest":false,"nonce":"isF+8Twgjhz0bOnKQEyoHcCnhKs3PYCbtLDdCvb3OHU=","rootUrl":"/en/","sheetUserCipher":null,"type":"help-center"},"theme":{"color":"2D00AD","siteName":"Productive Help Center","headline":"","headerFontColor":"FFFFFF","logo":"https://downloads.intercomcdn.com/i/o/555069/c46db78606979de5b10de666/1b738d52b69da9fed6134d1b044aa87d.png","logoHeight":"144","header":null,"favicon":"https://intercom.help/productive/assets/favicon","locale":"en","homeUrl":"https://app.productive.io/","social":null,"urlPrefixForDefaultDomain":"https://intercom.help/productive","customDomain":"help.productive.io","customDomainUsesSsl":true,"customizationOptions":{"customizationType":1,"header":{"backgroundColor":"#2D00AD","fontColor":"#FFFFFF","fadeToEdge":false,"backgroundGradient":null,"backgroundImageId":null,"backgroundImageUrl":null},"body":{"backgroundColor":"#ffffff","fontColor":null,"fadeToEdge":null,"backgroundGradient":null,"backgroundImageId":null},"footer":{"backgroundColor":"#ffffff","fontColor":"#2D00AD","fadeToEdge":null,"backgroundGradient":null,"backgroundImageId":null,"showRichTextField":null},"layout":{"homePage":{"blocks":[{"type":"collection-list","columns":2,"template":2},{"type":"article-list","columns":2,"enabled":false,"localizedContent":[{"title":"","locale":"en","links":[{"articleId":"empty_article_slot","type":"article-link"},{"articleId":"empty_article_slot","type":"article-link"},{"articleId":"empty_article_slot","type":"article-link"},{"articleId":"empty_article_slot","type":"article-link"}]}]},{"type":"content-block","enabled":false,"columns":1},{"type":"tickets-portal-link","enabled":false}]},"collectionsPage":{"showArticleDescriptions":false},"articlePage":{},"searchPage":{}},"collectionCard":{"global":{"backgroundColor":null,"fontColor":"2D00AD","fadeToEdge":null,"backgroundGradient":null,"backgroundImageId":null,"showIcons":true,"backgroundImageUrl":null},"collections":[]},"global":{"font":{"customFontFaces":[],"primary":null,"secondary":null},"componentStyle":{"card":{"type":"bordered","borderRadius":8}},"namedComponents":{"header":{"subheader":{"enabled":false,"style":{"backgroundColor":"#000000","fontColor":"#FFFFFF"}},"style":{"height":"245px","align":"start","justify":"end"}},"searchBar":{"style":{"width":"100%","borderRadius":10}},"footer":{"type":0}},"brand":{"colors":[],"websiteUrl":""}},"contentBlock":{"blockStyle":{"backgroundColor":"#ffffff","fontColor":"#1a1a1a","fadeToEdge":null,"backgroundGradient":null,"backgroundImageId":null,"backgroundImageUrl":null},"buttonOptions":{"backgroundColor":"#334BFA","fontColor":"#ffffff","borderRadius":6},"isFullWidth":false}},"helpCenterName":"Productive Help Center","footerLogo":"https://downloads.intercomcdn.com/i/o/295088/7d1e9e7d334295930dd163a3/801f1c6d85d7662e8810fa8dcc02754d.png","footerLogoHeight":"110","localisedInformation":{"contentBlock":{"locale":"en","title":"Content section title","withButton":false,"description":"","buttonTitle":"Button title","buttonUrl":""}}},"user":{"userId":"77a8a2f3-458c-40be-8118-98bd0842b654","role":"visitor_role"},"articleContent":{"articleId":"3933649","author":null,"blocks":[{"type":"paragraph","text":"In Productive, there is a field for just about everything, but sometimes you have your unique metric or calculation that isn't available by default.\u0026nbsp;","class":"no-margin"},{"type":"paragraph","text":" ","class":"no-margin"},{"type":"paragraph","text":"Luckily, you can use formulas to combine multiple fields into a custom formula field with simple mathematical operations. Note that formula fields are available for all numeric data across Productive!\u003cbr\u003e","class":"no-margin"},{"type":"paragraph","text":"To add your formula field, click on \u003cb\u003eFields\u003c/b\u003e \u0026gt; \u003cb\u003eAdd Formula\u003c/b\u003e.","class":"no-margin"},{"type":"paragraph","text":" ","class":"no-margin"},{"type":"image","url":"https://downloads.intercomcdn.com/i/o/957271338/285423ca4aafa1cc47c24c3b/Screenshot+2024-02-08+at+13.59.05.png?expires=1732751100\u0026signature=905d746778905f3240c726703b5c6653533e9ee96ad052f6b090892b5c400a5f\u0026req=fSUgFM5%2FnoJXFb4f3HP0gPXFBfruYMZiVDep7%2FPH9RUoye%2FFCKDA3ha%2BJEuf%0Amw9WjqaPYfZ8wMUgDQ%3D%3D%0A","width":2552,"height":1358},{"type":"paragraph","text":" ","class":"no-margin"},{"type":"image","url":"https://downloads.intercomcdn.com/i/o/957296534/d57fab281e28d353f48a9d1f/Screenshot+2024-02-08+at+14.24.11.png?expires=1732751100\u0026signature=a32ed749ab00aad2a0c1ef000b8c9943e6970298340af38d25643dbc4df9b222\u0026req=fSUgFMB4mIJbFb4f3HP0gAG0LFiEIGFrSS38dCJjiG%2F88OV9d%2BkvAgNq8UP4%0AzBuCUQWckpF7c6b%2BAQ%3D%3D%0A","width":1426,"height":1190,"displayWidth":450,"align":"center"},{"type":"heading","text":"\u003cbr\u003eCreating a new custom formula","idAttribute":"h_0f2d30172f"},{"type":"paragraph","text":"1) Begin by assigning a name to your new field.","class":"no-margin"},{"type":"paragraph","text":" ","class":"no-margin"},{"type":"paragraph","text":"2) Choose the values you wish to incorporate. Start by typing \"@\" to display a dropdown menu with available options. Combine these values using the following supported operations: ","class":"no-margin"},{"type":"unorderedNestedList","text":"- Addition (+)\n- Subtraction (-)\n- Multiplication (*)\n- Division (/)\n- Formulas can also be enclosed in brackets for clarity: (A - B) * C.","items":[{"content":[{"type":"paragraph","text":"Addition (+)","class":"no-margin"}]},{"content":[{"type":"paragraph","text":"Subtraction (-)","class":"no-margin"}]},{"content":[{"type":"paragraph","text":"Multiplication (*)","class":"no-margin"}]},{"content":[{"type":"paragraph","text":"Division (/)","class":"no-margin"}]},{"content":[{"type":"paragraph","text":"Formulas can also be enclosed in brackets for clarity: (A - B) * C.","class":"no-margin"}]}]},{"type":"paragraph","text":" ","class":"no-margin"},{"type":"heading","text":"Number formats in Productive ","idAttribute":"h_f94d7eb333"},{"type":"paragraph","text":"When inputting values in custom formulas, it's important to note that \u003cb\u003emoney values are counted in cents\u003c/b\u003e, while \u003cb\u003etime values are counted in minutes\u003c/b\u003e. This ensures accurate calculations and prevents any misunderstandings with the units being used.\u003cbr\u003e","class":"no-margin"},{"type":"unorderedNestedList","text":"- If you are adding a custom formula which will be \u003cb\u003etaking into account money values\u003c/b\u003e, the inserted value will be counted in cents.\u003cbr\u003e\u003cbr\u003eFor example, if you write \"\u003cb\u003e100\u003c/b\u003e\", the calculated value will be 1.00, so make sure to add two zeroes if needed. In other words, instead of 100 becoming 1.00, you will need to enter 10000 which will become 100.00.\u003cbr\u003e","items":[{"content":[{"type":"paragraph","text":"If you are adding a custom formula which will be \u003cb\u003etaking into account money values\u003c/b\u003e, the inserted value will be counted in cents.\u003cbr\u003e\u003cbr\u003eFor example, if you write \"\u003cb\u003e100\u003c/b\u003e\", the calculated value will be 1.00, so make sure to add two zeroes if needed. In other words, instead of 100 becoming 1.00, you will need to enter 10000 which will become 100.00.\u003cbr\u003e","class":"no-margin"}]}]},{"type":"unorderedNestedList","text":"- If you are adding a custom formula which will be \u003cb\u003etaking into account time values\u003c/b\u003e, the inserted value will be counted in minutes. \u003cbr\u003e\u003cbr\u003eIn other words, if you write \"100\", the calculated value will be 100 minutes, not hours.\u003cbr\u003e","items":[{"content":[{"type":"paragraph","text":"If you are adding a custom formula which will be \u003cb\u003etaking into account time values\u003c/b\u003e, the inserted value will be counted in minutes. \u003cbr\u003e\u003cbr\u003eIn other words, if you write \"100\", the calculated value will be 100 minutes, not hours.\u003cbr\u003e","class":"no-margin"}]}]},{"type":"callout","content":[{"type":"paragraph","text":"\u003cb\u003eCustom Formula Use Case\u003c/b\u003e\u003cbr\u003e\u003cbr\u003eLet's generate a field to showcase the difference between the time we estimated it would take to finish a project and the time we worked and logged in Productive. \u003cbr\u003e\u003cbr\u003eThe formula we want to use here is Estimated time - Worked time. We'll call our new field \"Remaining time\" for simplicity.\u003cbr\u003e\u003cbr\u003eAfter inputting the formula, click on \"Create Field\" to add it to your view.","class":"no-margin"},{"type":"paragraph","text":" ","class":"no-margin"},{"type":"image","url":"https://downloads.intercomcdn.com/i/o/410929917/69f9a0e6fff38514eea4a0e5/Slika+zaslona+2021-10-29+u+10.55.32.png?expires=1732751100\u0026signature=2a276ea86c176666e597a6235c9cf76dec5b1c6495b84083151bd7a2427e6fee\u0026req=cCEnH8t3lIBYFb4f3HP0gJey0NYpxKZ2hWokrfC9sPrMOrSsD9ETWGNl5FpK%0ATpKtCQKbr45fX3VIgA%3D%3D%0A","width":1316,"height":1000,"displayWidth":500,"align":"center"},{"type":"paragraph","text":" ","class":"no-margin"},{"type":"image","url":"https://downloads.intercomcdn.com/i/o/412224247/f5fa2696b43d6612d4da9165/Screenshot+2021-11-01+at+17.51.20.png?expires=1732751100\u0026signature=c2197f672663a67143165a4237a565b58020f09ef8da807a2fcaaa3709073535\u0026req=cCElFMt6n4VYFb4f3HP0gL08oBZ5Sr2%2FWrlqTQk2rtLuQiPspGJRrDnGdVaO%0AyGyUyR4rT033PT%2FqIA%3D%3D%0A","width":1774,"height":1002,"displayWidth":470,"align":"center"}],"style":{"backgroundColor":"#e3e7fa80","borderColor":"#334bfa33"}},{"type":"paragraph","text":" ","class":"no-margin"},{"type":"callout","content":[{"type":"paragraph","text":"\u003cb\u003ePro tip: Composite Formulas\u003c/b\u003e","class":"no-margin"},{"type":"paragraph","text":" ","class":"no-margin"},{"type":"paragraph","text":"In Productive, you can create composite formulas/fields by combining multiple formulas to calculate a single metric. ","class":"no-margin"},{"type":"paragraph","text":" ","class":"no-margin"},{"type":"paragraph","text":"For example, you can create the \"Total Time\" field, which is composed of two previously defined formulas \"Internal\" and \"Client\".","class":"no-margin"},{"type":"paragraph","text":" ","class":"no-margin"},{"type":"paragraph","text":" ","class":"no-margin"},{"type":"image","url":"https://downloads.intercomcdn.com/i/o/957292236/a6644233ba4722ceca78ef19/Screenshot+2024-02-08+at+14.19.48.png?expires=1732751100\u0026signature=a485973d4959367d22d275efcadcf5eb7cb589ffc569c6de79bb1c13abd0e211\u0026req=fSUgFMB8n4JZFb4f3HP0gMpu5oUnx4P5ATY7zfomsyyOgMqyKxTdpiTBBjhb%0Akprccn9jy%2BCvuYoQjQ%3D%3D%0A","width":2508,"height":1574,"displayWidth":500,"align":"center"}],"style":{"backgroundColor":"#e8e8e880","borderColor":"#73737633"}}],"collectionId":"10042407","description":"Learn how to create, add, and use custom formula fields in Productive.","id":"3269360","lastUpdated":"Updated over 4 months ago","relatedArticles":[{"title":"Creating and Adding Custom Fields","url":"https://help.productive.io/en/articles/3732248-creating-and-adding-custom-fields"},{"title":"Task Custom Fields","url":"https://help.productive.io/en/articles/4167962-task-custom-fields"},{"title":"Number Custom Field","url":"https://help.productive.io/en/articles/9557085-number-custom-field"},{"title":"Setting Up Utilization Targets","url":"https://help.productive.io/en/articles/9805366-setting-up-utilization-targets"},{"title":"Automations: Set Custom Field Values for Tasks","url":"https://help.productive.io/en/articles/10091471-automations-set-custom-field-values-for-tasks"}],"targetUserType":"everyone","title":"Formula Fields","showTableOfContents":true,"synced":false},"breadcrumbs":[{"url":"https://help.productive.io/en/collections/9262206-data-management-and-pdf-customization","name":"Data Management and PDF Customization"},{"url":"https://help.productive.io/en/collections/10042407-data-management","name":"Data Management"}],"selectedReaction":null,"showReactions":true,"themeCSSCustomProperties":{"--body-bg":"rgb(255, 255, 255)","--body-image":"none","--body-bg-rgb":"255, 255, 255","--body-border":"rgb(230, 230, 230)","--body-primary-color":"#1a1a1a","--body-secondary-color":"#737373","--body-reaction-bg":"rgb(242, 242, 242)","--body-reaction-text-color":"rgb(64, 64, 64)","--body-toc-active-border":"#737373","--body-toc-inactive-border":"#f2f2f2","--body-toc-inactive-color":"#737373","--body-toc-active-font-weight":400,"--body-table-border":"rgb(204, 204, 204)","--body-color":"hsl(0, 0%, 0%)","--footer-bg":"rgb(255, 255, 255)","--footer-image":"none","--footer-border":"rgb(230, 230, 230)","--footer-color":"hsl(256, 100%, 34%)","--header-bg":"rgb(45, 0, 173)","--header-image":"none","--header-color":"hsl(0, 0%, 100%)","--collection-card-bg":"rgb(255, 255, 255)","--collection-card-image":"none","--collection-card-color":"hsl(256, 100%, 34%)","--card-bg":"rgb(255, 255, 255)","--card-border-color":"rgb(230, 230, 230)","--card-border-inner-radius":"6px","--card-border-radius":"8px","--card-shadow":"0 1px 2px 0 rgb(0 0 0 / 0.05)","--search-bar-border-radius":"10px","--search-bar-width":"100%","--ticket-blue-bg-color":"#dce1f9","--ticket-blue-text-color":"#334bfa","--ticket-green-bg-color":"#d7efdc","--ticket-green-text-color":"#0f7134","--ticket-orange-bg-color":"#ffebdb","--ticket-orange-text-color":"#b24d00","--header-height":"245px","--header-subheader-background-color":"#000000","--header-subheader-font-color":"#FFFFFF","--content-block-bg":"rgb(255, 255, 255)","--content-block-image":"none","--content-block-color":"hsl(0, 0%, 10%)","--content-block-button-bg":"rgb(51, 75, 250)","--content-block-button-image":"none","--content-block-button-color":"hsl(0, 0%, 100%)","--content-block-button-radius":"6px","--primary-color":"hsl(256, 100%, 34%)","--primary-color-alpha-10":"hsla(256, 100%, 34%, 0.1)","--primary-color-alpha-60":"hsla(256, 100%, 34%, 0.6)","--text-on-primary-color":"#ffffff"},"intl":{"defaultLocale":"en","locale":"en","messages":{"layout.skip_to_main_content":"Skip to main content","article.attachment_icon":"Attachment icon","article.related_articles":"Related Articles","article.written_by":"Written by \u003cb\u003e{author}\u003c/b\u003e","article.table_of_contents":"Table of contents","breadcrumb.all_collections":"All Collections","collection.article_count.one":"{count} article","collection.article_count.other":"{count} articles","collection.articles_heading":"Articles","collection.sections_heading":"Collections","collection.written_by.one":"Written by \u003cb\u003e{author}\u003c/b\u003e","collection.written_by.two":"Written by \u003cb\u003e{author1}\u003c/b\u003e and \u003cb\u003e{author2}\u003c/b\u003e","collection.written_by.three":"Written by \u003cb\u003e{author1}\u003c/b\u003e, \u003cb\u003e{author2}\u003c/b\u003e and \u003cb\u003e{author3}\u003c/b\u003e","collection.written_by.four":"Written by \u003cb\u003e{author1}\u003c/b\u003e, \u003cb\u003e{author2}\u003c/b\u003e, \u003cb\u003e{author3}\u003c/b\u003e and 1 other","collection.written_by.other":"Written by \u003cb\u003e{author1}\u003c/b\u003e, \u003cb\u003e{author2}\u003c/b\u003e, \u003cb\u003e{author3}\u003c/b\u003e and {count} others","collection.by.one":"By {author}","collection.by.two":"By {author1} and 1 other","collection.by.other":"By {author1} and {count} others","collection.by.count_one":"1 author","collection.by.count_plural":"{count} authors","community_banner.tip":"Tip","community_banner.label":"\u003cb\u003eNeed more help?\u003c/b\u003e Get support from our {link}","community_banner.link_label":"Community Forum","community_banner.description":"Find answers and get help from Intercom Support and Community Experts","header.headline":"Advice and answers from the {appName} Team","header.menu.open":"Open menu","header.menu.close":"Close menu","locale_picker.aria_label":"Change language","not_authorized.cta":"You can try sending us a message or logging in at {link}","not_found.title":"Uh oh. That page doesn’t exist.","not_found.not_here":"That page isn’t here anymore","not_found.not_authorized":"Unable to load this article, you may need to sign in first","not_found.try_searching":"Try searching for your answer","not_found.send_a_message":"Or just send us a message","tickets_portal_bad_request.title":"No access to tickets portal","tickets_portal_bad_request.learn_more":"Learn more","tickets_portal_bad_request.send_a_message":"Please contact your admin.","no_articles.title":"Empty Help Center","no_articles.no_articles":"This Help Center doesn't have any articles or collections yet.","preview.invalid_preview":"There is no preview available for {previewType}","reaction_picker.did_this_answer_your_question":"Did this answer your question?","reaction_picker.reaction.disappointed.title":"Disappointed","reaction_picker.reaction.disappointed.aria_label":"Disappointed Reaction","reaction_picker.reaction.neutral.title":"Neutral","reaction_picker.reaction.neutral.aria_label":"Neutral Reaction","reaction_picker.reaction.smiley.title":"Smiley","reaction_picker.reaction.smiley.aria_label":"Smiley Reaction","search.box_placeholder":"Search for articles...","search.no_results":"We couldn't find any articles for:","search.clear_search":"Clear search query","search.successful":"Search results for:","search.submit_btn":"Search for articles","footer.powered_by":"We run on Intercom","footer.social.facebook":"Facebook","footer.social.linkedin":"LinkedIn","footer.social.twitter":"Twitter","tickets.title":"Tickets","tickets.company_selector_option":"{companyName}’s tickets","tickets.all_states":"All states","tickets.filters.company_tickets":"All tickets","tickets.filters.my_tickets":"Created by me","tickets.no_tickets_found":"No tickets found","tickets.navigation.home":"Home","tickets.navigation.tickets_portal":"Tickets portal","tickets.navigation.ticket_details":"Ticket #{ticketId}","tickets.view_conversation":"View conversation","tickets.send_message":"Send us a message","tickets.continue_conversation":"Continue the conversation","tickets.avatar_image.image_alt":"{firstName}’s avatar","tickets.fields.id":"Ticket ID","tickets.fields.type":"Ticket type","tickets.fields.title":"Title","tickets.fields.description":"Description","tickets.fields.created_by":"Created by","tickets.fields.email_for_notification":"You will be notified here and by email","tickets.fields.created_at":"Creation date","tickets.fields.state":"Ticket state","tickets.fields.assignee":"Assignee","tickets.link-block.title":"Tickets portal.","tickets.link-block.description":"Track the progress of all tickets related to your company.","tickets.states.submitted":"Submitted","tickets.states.in_progress":"In progress","tickets.states.waiting_on_customer":"Waiting on you","tickets.states.resolved":"Resolved","tickets.states.description.unassigned.submitted":"We will pick this up soon","tickets.states.description.assigned.submitted":"{assigneeName} will pick this up soon","tickets.states.description.unassigned.in_progress":"We are working on this!","tickets.states.description.assigned.in_progress":"{assigneeName} is working on this!","tickets.states.description.unassigned.waiting_on_customer":"We need more information from you","tickets.states.description.assigned.waiting_on_customer":"{assigneeName} needs more information from you","tickets.states.description.unassigned.resolved":"We have completed your ticket","tickets.states.description.assigned.resolved":"{assigneeName} has completed your ticket","tickets.attributes.boolean.true":"Yes","tickets.attributes.boolean.false":"No"}},"_sentryTraceData":"76701f79640544cc3c59245cf518f75a-ff3ee759043eec41-0","_sentryBaggage":"sentry-environment=production,sentry-release=pBE9iWbiWcYTeTlBTemWk,sentry-public_key=187f842308a64dea9f1f64d4b1b9c298,sentry-trace_id=76701f79640544cc3c59245cf518f75a,sentry-sampled=false"},"__N_SSP":true},"page":"/[helpCenterIdentifier]/[locale]/articles/[articleSlug]","query":{"helpCenterIdentifier":"productive","locale":"en","articleSlug":"3933649-formula-fields"},"buildId":"pBE9iWbiWcYTeTlBTemWk","assetPrefix":"https://static.intercomassets.com","isFallback":false,"isExperimentalCompile":false,"dynamicIds":[9807],"gssp":true,"scriptLoader":[]}</script></body></html>