ANYBODY STILL ONLINE? Need Help with a SYNTAX error | Community
Skip to main content
Level 9
Sep 19, 2020 2:38 AM UTC
Solved

ANYBODY STILL ONLINE? Need Help with a SYNTAX error

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.
SarahNaAccepted solution
Level 6
Sep 21, 2020 1:45 PM UTC

Would this work?

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

2 replies

SarahNaAccepted solution
Level 6
Sep 21, 2020 1:45 PM UTC

Would this work?

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

Translate
BenettaPeAuthor
Level 9
Sep 21, 2020 2:20 PM UTC

OMG - YES - this work - THANK YOU.

Translate