ANYBODY STILL ONLINE? Need Help with a SYNTAX error | Community
Skip to main content
B
BenettaPe
Level 9
September 19, 2020
Solved

ANYBODY STILL ONLINE? Need Help with a SYNTAX error

  • September 19, 2020
  • 1 reply
  • 485 views

I am using a Project report.

I want to find the task by the given name, if the task status is "Not Required", I want to display "NA", otherwise, I want to display the actual completion date of the task. This task status is customized (I created it) and the key is NRQ.

I have done every permeation possible - none with the desired results - there has to be a small syntax error on this - PLEASE give me a 2nd pair of eyes.... Thanks

valueexpression=IF(({name}="Target Date For Extraction Flag"&&IF({status}="NRQ")),"NA",{actualCompletionDate})

valueexpression=IF({name}="Target Date for Extraction Flag",{actualCompletionDate})

valueexpression=IF({name}="Target Date for Extraction Flag"&&IF({status}="NRQ","NA",{actualCompletionDate}))

valueexpression=IF({name}="Target Date for Extraction Flag",IF({status}="NRQ","NA",{actualCompletionDate}))

valueexpression=IF(({name}="Target Date for Extraction Flag"&&IF({status}="NRQ")),"NA",{actualCompletionDate})

valueexpression=IF(({name}="Target Date for Extraction Flag"&&{name}.{status}="NRQ"),"NA",{actualCompletionDate})

valueexpression=IF(({name}="Target Date for Extraction Flag"&&{status}="NRQ"),"NA",{actualCompletionDate})

valueexpression=IF(({name}="Target Date for Extraction Flag"&&IF({name}.{status}="NRQ")),"NA",{actualCompletionDate})

valueexpression=IF({name}="Target Date for Extraction Flag",IF({name}.{status}="NRQ","NA",{actualCompletionDate}))

IF(name="Target Date for Extraction Flag"&&status="NRQ","NA",{actualCompletionDate})

valueexpression=IF({status}="NRQ","NA",{actualCompletionDate})

valueexpression=IF({name}="Target Date for Extraction Flag"&&{status}="NRQ","NA",{actualCompletionDate})

    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 SarahNa

    Would this work?

    valueexpression=IF({name}="Target Date for Extraction Flag",IF({status}="NRQ","NA",{actualCompletionDate}))

    1 reply

    S
    SarahNaAccepted solution
    Level 6
    September 21, 2020

    Would this work?

    valueexpression=IF({name}="Target Date for Extraction Flag",IF({status}="NRQ","NA",{actualCompletionDate}))

      B
      BenettaPeAuthor
      Level 9
      September 21, 2020

      OMG - YES - this work - THANK YOU.

        Terms & ConditionsAccessibility statement

        Loading footer...