Create Calculated Fields in Custom Forms
Learn how to create date, time, and mathematical expressions in calculated fields to gather unique custom data about the work being done for your organization.
Learn the data expression structure
Learn the standard elements used when building expressions in Adobe Workfront.
416
{ "description": "Learn the standard elements used when building expressions in Adobe Workfront.", "duration": "PT0H6M56S", "embedUrl": "https://video.tv.adobe.com/v/335174/", "name": "Learn the data expression structure", "thumbnailUrl": [ "https://images-tv.adobe.com/mpcv3/b8f920e0-0298-4d82-9ec3-c17d4c9ceda9/be4a60a5-6b30-406c-bce9-53bacc671887/941952963227437a9b03c9a1d2905937_1668033857-100x56.jpg", "https://images-tv.adobe.com/mpcv3/b8f920e0-0298-4d82-9ec3-c17d4c9ceda9/be4a60a5-6b30-406c-bce9-53bacc671887/941952963227437a9b03c9a1d2905937_1668033858-150x85.jpg", "https://images-tv.adobe.com/mpcv3/b8f920e0-0298-4d82-9ec3-c17d4c9ceda9/be4a60a5-6b30-406c-bce9-53bacc671887/941952963227437a9b03c9a1d2905937_1668033858-200x113.jpg", "https://images-tv.adobe.com/mpcv3/b8f920e0-0298-4d82-9ec3-c17d4c9ceda9/be4a60a5-6b30-406c-bce9-53bacc671887/941952963227437a9b03c9a1d2905937_1668033858-220x124.jpg", "https://images-tv.adobe.com/mpcv3/b8f920e0-0298-4d82-9ec3-c17d4c9ceda9/be4a60a5-6b30-406c-bce9-53bacc671887/941952963227437a9b03c9a1d2905937_1668033859-236x133.jpg", "https://images-tv.adobe.com/mpcv3/b8f920e0-0298-4d82-9ec3-c17d4c9ceda9/be4a60a5-6b30-406c-bce9-53bacc671887/941952963227437a9b03c9a1d2905937_1668033859-290x163.jpg", "https://images-tv.adobe.com/mpcv3/b8f920e0-0298-4d82-9ec3-c17d4c9ceda9/be4a60a5-6b30-406c-bce9-53bacc671887/941952963227437a9b03c9a1d2905937_1668033859-420x236.jpg", "https://images-tv.adobe.com/mpcv3/b8f920e0-0298-4d82-9ec3-c17d4c9ceda9/be4a60a5-6b30-406c-bce9-53bacc671887/941952963227437a9b03c9a1d2905937_1668033859-640x360.jpg", "https://images-tv.adobe.com/mpcv3/b8f920e0-0298-4d82-9ec3-c17d4c9ceda9/be4a60a5-6b30-406c-bce9-53bacc671887/941952963227437a9b03c9a1d2905937_1668033860-1920x1080.jpg", "https://images-tv.adobe.com/mpcv3/b8f920e0-0298-4d82-9ec3-c17d4c9ceda9/be4a60a5-6b30-406c-bce9-53bacc671887/941952963227437a9b03c9a1d2905937_1668033860-666x375.jpg", "https://images-tv.adobe.com/mpcv3/b8f920e0-0298-4d82-9ec3-c17d4c9ceda9/be4a60a5-6b30-406c-bce9-53bacc671887/941952963227437a9b03c9a1d2905937_1668033860-720x405.jpg", "https://images-tv.adobe.com/mpcv3/b8f920e0-0298-4d82-9ec3-c17d4c9ceda9/be4a60a5-6b30-406c-bce9-53bacc671887/941952963227437a9b03c9a1d2905937_1668033860-960x540.jpg" ], "@type": [ "VideoObject", "LearningResource" ], "uploadDate": "2021-07-16T13:16:52Z", "hasPart": [], "educationLevel": [ "Experienced" ], "learningResourceType": "Learn the data expression structure" }
Create ADDDAYS, ADDWEEKDAY, ADDMONTHS, ADDYEARS expressions
Learn how to use and create the ADD expressions in a calculated field in Adobe Workfront.
249
{ "description": "Learn how to use and create the ADD expressions in a calculated field in Adobe Workfront.", "duration": "PT0H4M9S", "embedUrl": "https://video.tv.adobe.com/v/335175/", "name": "Create ADDDAYS, ADDWEEKDAY, ADDMONTHS, ADDYEARS expressions", "thumbnailUrl": [ "https://images-tv.adobe.com/mpcv3/b8f920e0-0298-4d82-9ec3-c17d4c9ceda9/3f12ee11-33df-488f-aad2-885b16e10258/5a33b9b2d12c413baf08669899495c8a_1668636768-100x56.jpg", "https://images-tv.adobe.com/mpcv3/b8f920e0-0298-4d82-9ec3-c17d4c9ceda9/3f12ee11-33df-488f-aad2-885b16e10258/5a33b9b2d12c413baf08669899495c8a_1668636768-150x85.jpg", "https://images-tv.adobe.com/mpcv3/b8f920e0-0298-4d82-9ec3-c17d4c9ceda9/3f12ee11-33df-488f-aad2-885b16e10258/5a33b9b2d12c413baf08669899495c8a_1668636768-200x113.jpg", "https://images-tv.adobe.com/mpcv3/b8f920e0-0298-4d82-9ec3-c17d4c9ceda9/3f12ee11-33df-488f-aad2-885b16e10258/5a33b9b2d12c413baf08669899495c8a_1668636768-220x124.jpg", "https://images-tv.adobe.com/mpcv3/b8f920e0-0298-4d82-9ec3-c17d4c9ceda9/3f12ee11-33df-488f-aad2-885b16e10258/5a33b9b2d12c413baf08669899495c8a_1668636768-236x133.jpg", "https://images-tv.adobe.com/mpcv3/b8f920e0-0298-4d82-9ec3-c17d4c9ceda9/3f12ee11-33df-488f-aad2-885b16e10258/5a33b9b2d12c413baf08669899495c8a_1668636769-290x163.jpg", "https://images-tv.adobe.com/mpcv3/b8f920e0-0298-4d82-9ec3-c17d4c9ceda9/3f12ee11-33df-488f-aad2-885b16e10258/5a33b9b2d12c413baf08669899495c8a_1668636769-420x236.jpg", "https://images-tv.adobe.com/mpcv3/b8f920e0-0298-4d82-9ec3-c17d4c9ceda9/3f12ee11-33df-488f-aad2-885b16e10258/5a33b9b2d12c413baf08669899495c8a_1668636769-640x360.jpg", "https://images-tv.adobe.com/mpcv3/b8f920e0-0298-4d82-9ec3-c17d4c9ceda9/3f12ee11-33df-488f-aad2-885b16e10258/5a33b9b2d12c413baf08669899495c8a_1668636769-666x375.jpg", "https://images-tv.adobe.com/mpcv3/b8f920e0-0298-4d82-9ec3-c17d4c9ceda9/3f12ee11-33df-488f-aad2-885b16e10258/5a33b9b2d12c413baf08669899495c8a_1668636769-720x405.jpg", "https://images-tv.adobe.com/mpcv3/b8f920e0-0298-4d82-9ec3-c17d4c9ceda9/3f12ee11-33df-488f-aad2-885b16e10258/5a33b9b2d12c413baf08669899495c8a_1668636769-960x540.jpg", "https://images-tv.adobe.com/mpcv3/b8f920e0-0298-4d82-9ec3-c17d4c9ceda9/3f12ee11-33df-488f-aad2-885b16e10258/5a33b9b2d12c413baf08669899495c8a_1668636770-1920x1080.jpg" ], "@type": [ "VideoObject", "LearningResource" ], "uploadDate": "2021-07-16T13:16:52Z", "hasPart": [], "educationLevel": [ "Experienced" ], "learningResourceType": "Create ADDDAYS, ADDWEEKDAY, ADDMONTHS, ADDYEARS expressions" }
Use the Calculation Editor
Use the new Calculation Editor to make creating calculated custom fields easier than ever.
385
{ "description": "Use the new Calculation Editor to make creating calculated custom fields easier than ever.", "duration": "PT0H6M25S", "embedUrl": "https://video.tv.adobe.com/v/339959/", "name": "Use the Calculation Editor", "thumbnailUrl": [ "https://images-tv.adobe.com/mpcv3/7414ca61-fecf-4d32-b53a-e22cdeee95ee/1bfb6f7e-50af-4f64-8e9a-6b917962c78a/12bfc21b44a94a248782068ccacb75f3_1663103307-100x56.jpg", "https://images-tv.adobe.com/mpcv3/7414ca61-fecf-4d32-b53a-e22cdeee95ee/1bfb6f7e-50af-4f64-8e9a-6b917962c78a/12bfc21b44a94a248782068ccacb75f3_1663103308-150x85.jpg", "https://images-tv.adobe.com/mpcv3/7414ca61-fecf-4d32-b53a-e22cdeee95ee/1bfb6f7e-50af-4f64-8e9a-6b917962c78a/12bfc21b44a94a248782068ccacb75f3_1663103308-200x113.jpg", "https://images-tv.adobe.com/mpcv3/7414ca61-fecf-4d32-b53a-e22cdeee95ee/1bfb6f7e-50af-4f64-8e9a-6b917962c78a/12bfc21b44a94a248782068ccacb75f3_1663103308-220x124.jpg", "https://images-tv.adobe.com/mpcv3/7414ca61-fecf-4d32-b53a-e22cdeee95ee/1bfb6f7e-50af-4f64-8e9a-6b917962c78a/12bfc21b44a94a248782068ccacb75f3_1663103308-236x133.jpg", "https://images-tv.adobe.com/mpcv3/7414ca61-fecf-4d32-b53a-e22cdeee95ee/1bfb6f7e-50af-4f64-8e9a-6b917962c78a/12bfc21b44a94a248782068ccacb75f3_1663103309-290x163.jpg", "https://images-tv.adobe.com/mpcv3/7414ca61-fecf-4d32-b53a-e22cdeee95ee/1bfb6f7e-50af-4f64-8e9a-6b917962c78a/12bfc21b44a94a248782068ccacb75f3_1663103309-420x236.jpg", "https://images-tv.adobe.com/mpcv3/7414ca61-fecf-4d32-b53a-e22cdeee95ee/1bfb6f7e-50af-4f64-8e9a-6b917962c78a/12bfc21b44a94a248782068ccacb75f3_1663103309-640x360.jpg", "https://images-tv.adobe.com/mpcv3/7414ca61-fecf-4d32-b53a-e22cdeee95ee/1bfb6f7e-50af-4f64-8e9a-6b917962c78a/12bfc21b44a94a248782068ccacb75f3_1663103309-666x375.jpg", "https://images-tv.adobe.com/mpcv3/7414ca61-fecf-4d32-b53a-e22cdeee95ee/1bfb6f7e-50af-4f64-8e9a-6b917962c78a/12bfc21b44a94a248782068ccacb75f3_1663103310-1920x1080.jpg", "https://images-tv.adobe.com/mpcv3/7414ca61-fecf-4d32-b53a-e22cdeee95ee/1bfb6f7e-50af-4f64-8e9a-6b917962c78a/12bfc21b44a94a248782068ccacb75f3_1663103310-720x405.jpg", "https://images-tv.adobe.com/mpcv3/7414ca61-fecf-4d32-b53a-e22cdeee95ee/1bfb6f7e-50af-4f64-8e9a-6b917962c78a/12bfc21b44a94a248782068ccacb75f3_1663103310-960x540.jpg" ], "@type": [ "VideoObject", "LearningResource" ], "uploadDate": "2022-01-21T20:57:21Z", "hasPart": [], "educationLevel": [ "Experienced" ], "learningResourceType": "Use the Calculation Editor" }
Create DATEDIFF and WEEKDAYDIFF expressions
Learn how to use and create the DATEDIFF expressions in a calculated field in Adobe Workfront.
337
{ "description": "Learn how to use and create the DATEDIFF expressions in a calculated field in Adobe Workfront.", "duration": "PT0H5M37S", "embedUrl": "https://video.tv.adobe.com/v/335176/", "name": "Create DATEDIFF and WEEKDAYDIFF expressions", "thumbnailUrl": [ "https://images-tv.adobe.com/mpcv3/b8f920e0-0298-4d82-9ec3-c17d4c9ceda9/4e9baa2b-aaa8-4119-9ba4-81179f90c410/94ab776fd15041f5964a2faa1028ea49_1670358944-100x56.jpg", "https://images-tv.adobe.com/mpcv3/b8f920e0-0298-4d82-9ec3-c17d4c9ceda9/4e9baa2b-aaa8-4119-9ba4-81179f90c410/94ab776fd15041f5964a2faa1028ea49_1670358944-150x85.jpg", "https://images-tv.adobe.com/mpcv3/b8f920e0-0298-4d82-9ec3-c17d4c9ceda9/4e9baa2b-aaa8-4119-9ba4-81179f90c410/94ab776fd15041f5964a2faa1028ea49_1670358945-200x113.jpg", "https://images-tv.adobe.com/mpcv3/b8f920e0-0298-4d82-9ec3-c17d4c9ceda9/4e9baa2b-aaa8-4119-9ba4-81179f90c410/94ab776fd15041f5964a2faa1028ea49_1670358945-220x124.jpg", "https://images-tv.adobe.com/mpcv3/b8f920e0-0298-4d82-9ec3-c17d4c9ceda9/4e9baa2b-aaa8-4119-9ba4-81179f90c410/94ab776fd15041f5964a2faa1028ea49_1670358945-236x133.jpg", "https://images-tv.adobe.com/mpcv3/b8f920e0-0298-4d82-9ec3-c17d4c9ceda9/4e9baa2b-aaa8-4119-9ba4-81179f90c410/94ab776fd15041f5964a2faa1028ea49_1670358946-290x163.jpg", "https://images-tv.adobe.com/mpcv3/b8f920e0-0298-4d82-9ec3-c17d4c9ceda9/4e9baa2b-aaa8-4119-9ba4-81179f90c410/94ab776fd15041f5964a2faa1028ea49_1670358946-420x236.jpg", "https://images-tv.adobe.com/mpcv3/b8f920e0-0298-4d82-9ec3-c17d4c9ceda9/4e9baa2b-aaa8-4119-9ba4-81179f90c410/94ab776fd15041f5964a2faa1028ea49_1670358946-640x360.jpg", "https://images-tv.adobe.com/mpcv3/b8f920e0-0298-4d82-9ec3-c17d4c9ceda9/4e9baa2b-aaa8-4119-9ba4-81179f90c410/94ab776fd15041f5964a2faa1028ea49_1670358946-666x375.jpg", "https://images-tv.adobe.com/mpcv3/b8f920e0-0298-4d82-9ec3-c17d4c9ceda9/4e9baa2b-aaa8-4119-9ba4-81179f90c410/94ab776fd15041f5964a2faa1028ea49_1670358947-1920x1080.jpg", "https://images-tv.adobe.com/mpcv3/b8f920e0-0298-4d82-9ec3-c17d4c9ceda9/4e9baa2b-aaa8-4119-9ba4-81179f90c410/94ab776fd15041f5964a2faa1028ea49_1670358947-720x405.jpg", "https://images-tv.adobe.com/mpcv3/b8f920e0-0298-4d82-9ec3-c17d4c9ceda9/4e9baa2b-aaa8-4119-9ba4-81179f90c410/94ab776fd15041f5964a2faa1028ea49_1670358947-960x540.jpg" ], "@type": [ "VideoObject", "LearningResource" ], "uploadDate": "2021-07-16T13:16:53Z", "hasPart": [], "educationLevel": [ "Experienced" ], "learningResourceType": "Create DATEDIFF and WEEKDAYDIFF expressions" }
Create a SUB, SUM, DIV, or PROD data expression
Learn how to use and create the basic mathematical expressions in the a calculated field in Adobe Workfront.
331
{ "description": "Learn how to use and create the basic mathematical expressions in the a calculated field in Adobe Workfront.", "duration": "PT0H5M31S", "embedUrl": "https://video.tv.adobe.com/v/335177/", "name": "Create a SUB, SUM, DIV, or PROD data expression", "thumbnailUrl": [ "https://images-tv.adobe.com/mpcv3/b8f920e0-0298-4d82-9ec3-c17d4c9ceda9/7cf5e2c2-7ab4-477b-a611-6dd042a9d5ab/95f27ee3f7d04ac8b726242423543714_1667838561-100x56.jpg", "https://images-tv.adobe.com/mpcv3/b8f920e0-0298-4d82-9ec3-c17d4c9ceda9/7cf5e2c2-7ab4-477b-a611-6dd042a9d5ab/95f27ee3f7d04ac8b726242423543714_1667838561-150x85.jpg", "https://images-tv.adobe.com/mpcv3/b8f920e0-0298-4d82-9ec3-c17d4c9ceda9/7cf5e2c2-7ab4-477b-a611-6dd042a9d5ab/95f27ee3f7d04ac8b726242423543714_1667838561-200x113.jpg", "https://images-tv.adobe.com/mpcv3/b8f920e0-0298-4d82-9ec3-c17d4c9ceda9/7cf5e2c2-7ab4-477b-a611-6dd042a9d5ab/95f27ee3f7d04ac8b726242423543714_1667838561-220x124.jpg", "https://images-tv.adobe.com/mpcv3/b8f920e0-0298-4d82-9ec3-c17d4c9ceda9/7cf5e2c2-7ab4-477b-a611-6dd042a9d5ab/95f27ee3f7d04ac8b726242423543714_1667838562-236x133.jpg", "https://images-tv.adobe.com/mpcv3/b8f920e0-0298-4d82-9ec3-c17d4c9ceda9/7cf5e2c2-7ab4-477b-a611-6dd042a9d5ab/95f27ee3f7d04ac8b726242423543714_1667838562-290x163.jpg", "https://images-tv.adobe.com/mpcv3/b8f920e0-0298-4d82-9ec3-c17d4c9ceda9/7cf5e2c2-7ab4-477b-a611-6dd042a9d5ab/95f27ee3f7d04ac8b726242423543714_1667838562-420x236.jpg", "https://images-tv.adobe.com/mpcv3/b8f920e0-0298-4d82-9ec3-c17d4c9ceda9/7cf5e2c2-7ab4-477b-a611-6dd042a9d5ab/95f27ee3f7d04ac8b726242423543714_1667838562-640x360.jpg", "https://images-tv.adobe.com/mpcv3/b8f920e0-0298-4d82-9ec3-c17d4c9ceda9/7cf5e2c2-7ab4-477b-a611-6dd042a9d5ab/95f27ee3f7d04ac8b726242423543714_1667838562-666x375.jpg", "https://images-tv.adobe.com/mpcv3/b8f920e0-0298-4d82-9ec3-c17d4c9ceda9/7cf5e2c2-7ab4-477b-a611-6dd042a9d5ab/95f27ee3f7d04ac8b726242423543714_1667838563-1920x1080.jpg", "https://images-tv.adobe.com/mpcv3/b8f920e0-0298-4d82-9ec3-c17d4c9ceda9/7cf5e2c2-7ab4-477b-a611-6dd042a9d5ab/95f27ee3f7d04ac8b726242423543714_1667838563-720x405.jpg", "https://images-tv.adobe.com/mpcv3/b8f920e0-0298-4d82-9ec3-c17d4c9ceda9/7cf5e2c2-7ab4-477b-a611-6dd042a9d5ab/95f27ee3f7d04ac8b726242423543714_1667838563-960x540.jpg" ], "@type": [ "VideoObject", "LearningResource" ], "uploadDate": "2021-07-16T13:16:53Z", "hasPart": [], "educationLevel": [ "Experienced" ], "learningResourceType": "Create a SUB, SUM, DIV, or PROD data expression" }