Can someone help me with a calculated field? I'm trying to add a field that tells me when a task or issue is added to an iteration. I can't seem to get the expression correct. | Community
Skip to main content
MelissaDa5
MelissaDa5
Level 3
April 24, 2020
Solved

Can someone help me with a calculated field? I'm trying to add a field that tells me when a task or issue is added to an iteration. I can't seem to get the expression correct.

  • April 24, 2020
  • 1 reply
  • 1053 views

My plan is to add a calculated field that notes when the iteration ID has a value but I can't determine how to do this so that it adds a timestamp of the first time ANY value is present in that field. Here's where I am and this doesn't work:

IF(NOTBLANK{Iteration ID}),IF(ISBLANK({DE:Iteration Assigned Date}),$$NOW,{DE:Iteration Assigned Date}),{DE:Iteration Assigned Date})

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by Doug_Den_Hoed_AtAppStore

    Hi Melissa,

    From this handy Calculated Data Expressions article, I believe the term "ISBLANK" (vs NOTBLANK) is what you're after, and suggest you try this formula instead:

    IF(ISBLANK({Iteration ID})

    ,{DE:Iteration Assigned Date}

    ,IF(ISBLANK({DE:Iteration Assigned Date})

    ,$$NOW

    ,{DE:Iteration Assigned Date}

    )

    )

    Regards,

    Doug

    1 reply

    Doug_Den_Hoed_AtAppStore
    Community Advisor
    Doug_Den_Hoed_AtAppStoreCommunity AdvisorAccepted solution
    Community Advisor
    April 24, 2020

    Hi Melissa,

    From this handy Calculated Data Expressions article, I believe the term "ISBLANK" (vs NOTBLANK) is what you're after, and suggest you try this formula instead:

    IF(ISBLANK({Iteration ID})

    ,{DE:Iteration Assigned Date}

    ,IF(ISBLANK({DE:Iteration Assigned Date})

    ,$$NOW

    ,{DE:Iteration Assigned Date}

    )

    )

    Regards,

    Doug

      D
      DarylMa1
      Level 2
      October 21, 2020

      Doug, thanks for the post. I was having a similar issue and your answer helped me solve the problem. Have a good day.

      Terms & ConditionsAccessibility statement

      Loading footer...