[Follow-up] Calculated Custom Fields Workshop | Community
Skip to main content
NicholeVargas
Adobe Employee
NicholeVargasAdobe Employee
Adobe Employee
May 11, 2023

[Follow-up] Calculated Custom Fields Workshop

  • May 11, 2023
  • 5 replies
  • 4788 views

 

Thank you to all who attended and participated in today's Calculated Custom Field workshop with the Adobe Workfront Customer Success team. There were so many great ideas shared in the chat, so I'll add those as replies below.

If you missed the session, no worries - here is a link to the recording (expired May 2024) and a copy of the slide deck with instructions and ready-to-use formulas is attached. We discussed best practices and tips for creating custom forms and walked through 3 calculated custom field examples:

  1. Identify the date(s) of status changes - use this to understand how long a work item was in a specific status (ex: On Hold)
  2. Link to a tab on an object (ex: Link to Hours tab -- creating a clickable URL for users "Click here to log time")
  3. Calculate the number of days between Actual Start and Planned Start or Actual Completion and Planned Completion

I encourage those in attendance to share the formulas and a short description of the calculated custom fields your organization uses so that others can take advantage! 

UP-LIKE IDEA [from Helen]: Save a custom report or list view as global View 

 

    5 replies

    NicholeVargas
    Adobe Employee
    NicholeVargasAdobe EmployeeAuthor
    Adobe Employee
    May 11, 2023

    [From Karlton]

    Custom Field Name: Days a User is Inactive

    Format: Number

    Calculated Expression: ROUND(DATEDIFF($$NOW,{lastLoginDate}),0)  

      NicholeVargas
      Adobe Employee
      NicholeVargasAdobe EmployeeAuthor
      Adobe Employee
      May 11, 2023

      [From Monique]

      Status Comments History Field.

      TYPE: Text field

      NOTES: Points to itself and a field called Status Comments

      FORMULA:
      LEFT(IF(LEFT(Status Comments History,LEN(IF(ISBLANK({Status Comments}),"-",{Status Comments})))={Status Comments},Status Comments History,CONCAT(IF(ISBLANK({Status Comments}),"-",{Status Comments})," (",$$NOW,") | ",{Status Comments History})),2000)

      NicholeVargas
      Adobe Employee
      NicholeVargasAdobe EmployeeAuthor
      Adobe Employee
      May 11, 2023

      [From Madalyn]

      Custom Field Name: Project Entry to Completion field

      Format: Number

      Calculated Expression: ROUND(DATEDIFF({actualCompletionDate}, {entryDate}),1)

       

      Custom Field Name: Project Current to Completion field

      Format: Number

      Calculated Expression: IF({status}="CPL",ROUND(DATEDIFF({DE:Date Went Current},{actualCompletionDate}),2))

       

      Custom Field Name: Date Project went Current field

      Format: Date

      Calculated Expression: IF(ISBLANK({DE:Date Went Current}),IF({status}="CUR",$$NOW),{DE:Date Went Current})

      Madalyn_Destafney
      Community Advisor
      Madalyn_DestafneyCommunity Advisor
      Community Advisor
      May 11, 2023

      Thanks for adding for me, @nicholevargas  : )

      If this helped you, please mark correct to help others : )
        Kurt_Jones
        Community Advisor
        Kurt_JonesCommunity Advisor
        Community Advisor
        May 11, 2023

        Custom Field Name: Completion Range Percentage

        Format: Text

        Calculated Expression:  

        IF({percentComplete}<"25","< 25%",IF({percentComplete}<="50","25-50%",IF({percentComplete}<="75","50-75%",IF({percentComplete}>="75","> 75%"))))
          L
          ljorr16
          September 23, 2024

          Hi Nicole! Is the video available to view?

          NicholeVargas
          Adobe Employee
          NicholeVargasAdobe EmployeeAuthor
          Adobe Employee
          September 23, 2024

          @ljorr16 Unfortunately, the recordings from our events only have a 1-year shelf life, so the link has expired. Based on customer feedback, this will likely be a topic for a future Scale Customer Success workshop so keep an eye out on Experience League! 

          If you have any specific questions around the slide deck, though, let me know! 

            NicholeVargas
            Adobe Employee
            NicholeVargasAdobe EmployeeAuthor
            Adobe Employee
            July 9, 2025

            I'm so sorry, I was trying to figure out how one could add a column that allowed a user to click to make a project update!


            Apologies for that! You should just be able to swap the word hours for updates and it should take a user to the Updates tab of the project. Again, they aren't going to be able to in-line edit and post an update through the report, but this would provide them with a single click to get there. 

            -----

            If you've migrated to the Adobe Admin Console, the text/link for your calculated custom field would look like this instead: CONCAT("https://experience.adobe.com/#/@domain/so:domain-Production/workfront/project/",{ID},"/updates")

            You'll want to replace the bold domain text with the domain of your Workfront instance (found in your URL). 
             
            If you haven't migrated, the text/link for your calculated custom field would look like this: CONCAT("https://domain.my.workfront.com","/","project/view?ID="
            ,{ID},"&activeTab=list-project-updates")
            Again, you'll want to replace the bold domain text with the domain of your Workfront instance.
              Terms & ConditionsAccessibility statement

              Loading footer...