Text Mode formula for the Task report | Community
Skip to main content
D
DeepaMa1
Level 2
July 7, 2026
Solved

Text Mode formula for the Task report

  • July 7, 2026
  • 2 replies
  • 11 views

Hello,

I’m having trouble figuring out the Text Mode code for my Task Report. How can I write the code in the Value Expression to achieve the following result? I would like to display the date difference in one field.

 

IF ISBLANK({project}.{DE:EWIR Submission Date}) display ""
else

calculate WEEKDAYDIFF({project}.{DE:EWIR Submission Date},{actualCompletionDate})
    
IF ISBLANK({project}.{DE:EFIR Submission Date}) display ""
else
calculate WEEKDAYDIFF({project}.{DE:EFIR Submission Date},{actualCompletionDate})

 

Thank you,

Deepa Mahishi

    Best answer by KellieGardner

    You can try this:

    IF(ISBLANK({project}.{DE:EWIR Submission Date}),IF(ISBLANK({project}.{DE:EFIR Submission Date}),"",WEEKDAYDIFF({project}.{DE:EFIR Submission Date},{actualCompletionDate})),WEEKDAYDIFF({project}.{DE:EWIR Submission Date},{actualCompletionDate}))

     

    How it reads:

    Outer IF: is EWIR Submission Date blank?

    • If yes → go to the inner IF: is EFIR Submission Date also blank?
      • If yes → display "" (blank)
      • If no → calculate WEEKDAYDIFF using EFIR
    • If no (EWIR has a value) → calculate WEEKDAYDIFF using EWIR

    2 replies

    KellieGardner
    Community Advisor and Adobe Champion
    KellieGardnerCommunity Advisor and Adobe ChampionAccepted solution
    Community Advisor and Adobe Champion
    July 7, 2026

    You can try this:

    IF(ISBLANK({project}.{DE:EWIR Submission Date}),IF(ISBLANK({project}.{DE:EFIR Submission Date}),"",WEEKDAYDIFF({project}.{DE:EFIR Submission Date},{actualCompletionDate})),WEEKDAYDIFF({project}.{DE:EWIR Submission Date},{actualCompletionDate}))

     

    How it reads:

    Outer IF: is EWIR Submission Date blank?

    • If yes → go to the inner IF: is EFIR Submission Date also blank?
      • If yes → display "" (blank)
      • If no → calculate WEEKDAYDIFF using EFIR
    • If no (EWIR has a value) → calculate WEEKDAYDIFF using EWIR
    D
    DeepaMa1Author
    Level 2
    July 7, 2026

    ​@KellieGardner Thank you for the quick response. 

      Terms & ConditionsAccessibility statement

      Loading footer...