4

I have a column in SP called Pursuit status that contains various states a proposal can be in. For a diffrent project I need to lump them into 3 buckets (win - loss - pending)

The fields below are:

  • Go Pending
  • Go – Capture
  • No Go
  • Bid – Proposal
  • No Bid
  • Proposal Submitted
  • Win
  • Loss
  • Complete
  • Canceled

If I were going to do this in C# it would be something like

var cell=""
if( pursuit status = Win)
{
Cell = "Win";
}
else if (pursuit status = "no go" || "No Bid" || "Loss")
{
Cell = "Loss";
}
else
{
Cell = "Pending";
}

How would can I achive the same results in a calculated field?

Best I have so far:

=IF([Column1]="Win", "Win", "Loss")
0

3 Answers 3

2

SharePoint syntax is exactly the same as Excel.

=IF( condition1 , IF( condition2, TRUE , FALSE) , IF( condition3, TRUE , FALSE) )

So for complex Formulas its possible to create/test in Excel (with named ranges) and paste the Formula to SharePoint

!! SharePoint has the limitation of maximum 7 levels deep nested calls !!

All Functions that work in SharePoint: https://www.365csi.nl/vm365com/365coach/#/Calculated_Column_Functions_List

2
  • Hi @Danny ..I have same requirement to convert 12 german month name to digits ..there is limitation only 7 nested if ...do we any other solution?
    – Ankush
    Jul 27, 2020 at 13:12
  • Then you have to spread your formula over multiple "columns", just like you would do in Excel IF excel had the same 7 level limitation. Note I left the SharePoint world years ago... I will remove the broken link from this post Jul 27, 2020 at 14:56
0

You can nest if statements as below

=IF(PursuitStatus="Win", "Win", IF(PursuitStatus="Loss", "Loss", "Pending"))

In the place of pending you can add remaining if conditions

0

Below solution worked for me. Thank you so much.

=IF([Column1]="Win", "Win", "Loss")
0

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.