1

this is my current formula(see below). Right now I am adding admendment, however I only want it to add admendment if request status - amendment but I need help with this formula

=[Date Formula]
 &" "
 &"SP"
 &" "
 &[SharePoint ID]
 &" "
 &[Contract Manufacturer Name]
 &"  "
 &[PeopleSoft Contract ID]
 &" "
 &"Amendment"
 &" "
 &[Contract Ancillary Number] 

2 Answers 2

2

Syntax would be - IF("specify condition", "if true", "if false")

IF([Request Status]="Amendment",[Amendment],"")

Try below

=[Date Formula]
 &" "
 &"SP"
 &" "
 &[SharePoint ID]
 &" "
 &[Contract Manufacturer Name]
 &"  "
 &[PeopleSoft Contract ID]
 &" "
 &IF([Request Status]="amendment",[Amendment]&" ","")
 &[Contract Ancillary Number] 
2
  • At first glance this looks right except for the case where the IF statement is false. If false, you would end up with two spaces between [PeopleSoft Contract ID] and [Contract Ancillary Number]. You'll need to include the spacing in the IF statement.
    – Arknev
    Jan 23, 2017 at 20:30
  • You are absolutely right, made the correction
    – Harini
    Jan 23, 2017 at 20:42
0

I figured it out. I had to remove the brackets around Amendment

=[Date Formula]&" "&"SP"&" "&[SharePoint ID]&" "&[Contract Manufacturer Name]&" "&[PeopleSoft Contract ID]&" "&IF([Request Type]="Amendment","Amendment"&" ","")&[Contract Ancillary Number]

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.