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.

https://video.tv.adobe.com/v/335174?learn=on

Learn the data expression structure

Learn the data expression structure

Learn the standard elements used when building expressions in Adobe Workfront.

416

https://video.tv.adobe.com/vc/335174/eng.json

{ "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" }

https://video.tv.adobe.com/v/335175?learn=on

Create ADDDAYS, ADDWEEKDAY, ADDMONTHS, ADDYEARS expressions

Create ADDDAYS, ADDWEEKDAY, ADDMONTHS, ADDYEARS expressions

Learn how to use and create the ADD expressions in a calculated field in Adobe Workfront.

249

https://video.tv.adobe.com/vc/335175/eng.json

{ "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" }

https://video.tv.adobe.com/v/339959?learn=on

Use the Calculation Editor

Use the Calculation Editor

Use the new Calculation Editor to make creating calculated custom fields easier than ever.

385

https://video.tv.adobe.com/vc/339959/eng.json

{ "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" }

https://video.tv.adobe.com/v/335176?learn=on

Create DATEDIFF and WEEKDAYDIFF expressions

Create DATEDIFF and WEEKDAYDIFF expressions

Learn how to use and create the DATEDIFF expressions in a calculated field in Adobe Workfront.

337

https://video.tv.adobe.com/vc/335176/eng.json

{ "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" }

https://video.tv.adobe.com/v/335177?learn=on

Create a SUB, SUM, DIV, or PROD data expression

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

https://video.tv.adobe.com/vc/335177/eng.json

{ "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" }