Calculated Column IF/AND question

Clash Royale CLAN TAG#URR8PPP

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty margin-bottom:0;

up vote
1
down vote

favorite

What did I do wrong?

I need a calculated column to return the following:

• If [Status] equals "Pre-OPEN" then return [Date Opened]+3


• If [Status] equals "OPEN" then return [Date Opened]+30


• If [Status] equals "PENDING" then return [Date Opened]+30


• If [Status] equals "REFERRAL" and [Dispo] equals "Active" then return [Date Opened] +5


• 
  

  If [Status] equals "Pre-OPEN" and [Dispo] equals "Active" then return [Date Opened]+3

  
  
  

  =IF([Status]="Pre-OPEN",[Date Opened]+3,IF([Status]="OPEN",[Date of Last ROI]+30,IF([Status]="PENDING",[Date of Last ROI]+30,IF(AND([Status]="REFERRAL",[Dispo]=”Active”,[Date Opened]+5,IF(AND([Status]="ONLY",[Dispo]=”Active”,[Date Opened]+10, "")))))
  

  
  

Any assistance is much appreciated.

calculated-column calculated-column-formula

share|improve this question

edited 25 mins ago

Mohamed El-Qassas MVP♦

36.3k53880

asked 34 mins ago

Ulcsmarine001

173

New contributor

Ulcsmarine001 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

up vote
1
down vote

favorite

What did I do wrong?

I need a calculated column to return the following:

• If [Status] equals "Pre-OPEN" then return [Date Opened]+3


• If [Status] equals "OPEN" then return [Date Opened]+30


• If [Status] equals "PENDING" then return [Date Opened]+30


• If [Status] equals "REFERRAL" and [Dispo] equals "Active" then return [Date Opened] +5


• 
  

  If [Status] equals "Pre-OPEN" and [Dispo] equals "Active" then return [Date Opened]+3

  
  
  

  =IF([Status]="Pre-OPEN",[Date Opened]+3,IF([Status]="OPEN",[Date of Last ROI]+30,IF([Status]="PENDING",[Date of Last ROI]+30,IF(AND([Status]="REFERRAL",[Dispo]=”Active”,[Date Opened]+5,IF(AND([Status]="ONLY",[Dispo]=”Active”,[Date Opened]+10, "")))))
  

  
  

Any assistance is much appreciated.

calculated-column calculated-column-formula

share|improve this question

edited 25 mins ago

Mohamed El-Qassas MVP♦

36.3k53880

asked 34 mins ago

Ulcsmarine001

173

New contributor

Ulcsmarine001 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

up vote
1
down vote

favorite

up vote
1
down vote

favorite

What did I do wrong?

I need a calculated column to return the following:

• If [Status] equals "Pre-OPEN" then return [Date Opened]+3


• If [Status] equals "OPEN" then return [Date Opened]+30


• If [Status] equals "PENDING" then return [Date Opened]+30


• If [Status] equals "REFERRAL" and [Dispo] equals "Active" then return [Date Opened] +5


• 
  

  If [Status] equals "Pre-OPEN" and [Dispo] equals "Active" then return [Date Opened]+3

  
  
  

  =IF([Status]="Pre-OPEN",[Date Opened]+3,IF([Status]="OPEN",[Date of Last ROI]+30,IF([Status]="PENDING",[Date of Last ROI]+30,IF(AND([Status]="REFERRAL",[Dispo]=”Active”,[Date Opened]+5,IF(AND([Status]="ONLY",[Dispo]=”Active”,[Date Opened]+10, "")))))
  

  
  

Any assistance is much appreciated.

calculated-column calculated-column-formula

share|improve this question

edited 25 mins ago

Mohamed El-Qassas MVP♦

36.3k53880

asked 34 mins ago

Ulcsmarine001

173

New contributor

Ulcsmarine001 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

What did I do wrong?

I need a calculated column to return the following:

• If [Status] equals "Pre-OPEN" then return [Date Opened]+3


• If [Status] equals "OPEN" then return [Date Opened]+30


• If [Status] equals "PENDING" then return [Date Opened]+30


• If [Status] equals "REFERRAL" and [Dispo] equals "Active" then return [Date Opened] +5


• 
  

  If [Status] equals "Pre-OPEN" and [Dispo] equals "Active" then return [Date Opened]+3

  
  
  

  =IF([Status]="Pre-OPEN",[Date Opened]+3,IF([Status]="OPEN",[Date of Last ROI]+30,IF([Status]="PENDING",[Date of Last ROI]+30,IF(AND([Status]="REFERRAL",[Dispo]=”Active”,[Date Opened]+5,IF(AND([Status]="ONLY",[Dispo]=”Active”,[Date Opened]+10, "")))))
  

  
  

Any assistance is much appreciated.

calculated-column calculated-column-formula

calculated-column calculated-column-formula

share|improve this question

edited 25 mins ago

Mohamed El-Qassas MVP♦

36.3k53880

asked 34 mins ago

Ulcsmarine001

173

New contributor

Ulcsmarine001 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share|improve this question

edited 25 mins ago

Mohamed El-Qassas MVP♦

36.3k53880

asked 34 mins ago

Ulcsmarine001

173

New contributor

Ulcsmarine001 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share|improve this question

share|improve this question

edited 25 mins ago

Mohamed El-Qassas MVP♦

36.3k53880

edited 25 mins ago

Mohamed El-Qassas MVP♦

36.3k53880

edited 25 mins ago

Mohamed El-Qassas MVP♦

36.3k53880

36.3k53880

asked 34 mins ago

Ulcsmarine001

173

New contributor

Ulcsmarine001 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 34 mins ago

Ulcsmarine001

173

asked 34 mins ago

Ulcsmarine001

173

173

New contributor

Ulcsmarine001 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

New contributor

Ulcsmarine001 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

Ulcsmarine001 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

add a comment | 

1 Answer
1

active

oldest

votes

up vote
3
down vote



accepted

You are missing AND condition close and you need to close it with additional ) as the following

AND([Status]="REFERRAL",[Dispo]="Active")

So the formula should be

=

IF([Status]="Pre-OPEN",[Date Opened]+3,

IF([Status]="OPEN",[Date of Last ROI]+30,

IF([Status]="PENDING",[Date of Last ROI]+30,

IF(AND([Status]="REFERRAL",[Dispo]="Active"),[Date Opened]+5,

IF(AND([Status]="ONLY",[Dispo]="Active"),[Date Opened]+10, "")))))

share|improve this answer

answered 27 mins ago

Mohamed El-Qassas MVP♦

36.3k53880

• 
  
  
  

  
  

  
  
  
  
  
  

  
  Worked great! Thanks
  – Ulcsmarine001
  8 mins ago
  

  
  
  
  

add a comment | 

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "232"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
convertImagesToLinks: false,
noModals: false,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

Ulcsmarine001 is a new contributor. Be nice, and check out our Code of Conduct.

 

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name Email

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsharepoint.stackexchange.com%2fquestions%2f250132%2fcalculated-column-if-and-question%23new-answer', 'question_page');

);

Post as a guest

Name Email

1 Answer
1

active

oldest

votes

1 Answer
1

active

oldest

votes

active

oldest

votes

active

oldest

votes

up vote
3
down vote



accepted

You are missing AND condition close and you need to close it with additional ) as the following

AND([Status]="REFERRAL",[Dispo]="Active")

So the formula should be

=

IF([Status]="Pre-OPEN",[Date Opened]+3,

IF([Status]="OPEN",[Date of Last ROI]+30,

IF([Status]="PENDING",[Date of Last ROI]+30,

IF(AND([Status]="REFERRAL",[Dispo]="Active"),[Date Opened]+5,

IF(AND([Status]="ONLY",[Dispo]="Active"),[Date Opened]+10, "")))))

share|improve this answer

answered 27 mins ago

Mohamed El-Qassas MVP♦

36.3k53880

• 
  
  
  

  
  

  
  
  
  
  
  

  
  Worked great! Thanks
  – Ulcsmarine001
  8 mins ago
  

  
  
  
  

add a comment | 

up vote
3
down vote



accepted

You are missing AND condition close and you need to close it with additional ) as the following

AND([Status]="REFERRAL",[Dispo]="Active")

So the formula should be

=

IF([Status]="Pre-OPEN",[Date Opened]+3,

IF([Status]="OPEN",[Date of Last ROI]+30,

IF([Status]="PENDING",[Date of Last ROI]+30,

IF(AND([Status]="REFERRAL",[Dispo]="Active"),[Date Opened]+5,

IF(AND([Status]="ONLY",[Dispo]="Active"),[Date Opened]+10, "")))))

share|improve this answer

answered 27 mins ago

Mohamed El-Qassas MVP♦

36.3k53880

• 
  
  
  

  
  

  
  
  
  
  
  

  
  Worked great! Thanks
  – Ulcsmarine001
  8 mins ago
  

  
  
  
  

add a comment | 

up vote
3
down vote



accepted

up vote
3
down vote



accepted

You are missing AND condition close and you need to close it with additional ) as the following

AND([Status]="REFERRAL",[Dispo]="Active")

So the formula should be

=

IF([Status]="Pre-OPEN",[Date Opened]+3,

IF([Status]="OPEN",[Date of Last ROI]+30,

IF([Status]="PENDING",[Date of Last ROI]+30,

IF(AND([Status]="REFERRAL",[Dispo]="Active"),[Date Opened]+5,

IF(AND([Status]="ONLY",[Dispo]="Active"),[Date Opened]+10, "")))))

share|improve this answer

answered 27 mins ago

Mohamed El-Qassas MVP♦

36.3k53880

You are missing AND condition close and you need to close it with additional ) as the following

AND([Status]="REFERRAL",[Dispo]="Active")

So the formula should be

=

IF([Status]="Pre-OPEN",[Date Opened]+3,

IF([Status]="OPEN",[Date of Last ROI]+30,

IF([Status]="PENDING",[Date of Last ROI]+30,

IF(AND([Status]="REFERRAL",[Dispo]="Active"),[Date Opened]+5,

IF(AND([Status]="ONLY",[Dispo]="Active"),[Date Opened]+10, "")))))

share|improve this answer

answered 27 mins ago

Mohamed El-Qassas MVP♦

36.3k53880

share|improve this answer

share|improve this answer

answered 27 mins ago

Mohamed El-Qassas MVP♦

36.3k53880

answered 27 mins ago

Mohamed El-Qassas MVP♦

36.3k53880

answered 27 mins ago

Mohamed El-Qassas MVP♦

36.3k53880

36.3k53880

• 
  
  
  

  
  

  
  
  
  
  
  

  
  Worked great! Thanks
  – Ulcsmarine001
  8 mins ago
  

  
  
  
  

add a comment | 

• 
  
  
  

  
  

  
  
  
  
  
  

  
  Worked great! Thanks
  – Ulcsmarine001
  8 mins ago
  

  
  
  
  

Worked great! Thanks
– Ulcsmarine001
8 mins ago

Worked great! Thanks
– Ulcsmarine001
8 mins ago

add a comment | 

Ulcsmarine001 is a new contributor. Be nice, and check out our Code of Conduct.

 

draft saved

draft discarded

Ulcsmarine001 is a new contributor. Be nice, and check out our Code of Conduct.

Ulcsmarine001 is a new contributor. Be nice, and check out our Code of Conduct.

Ulcsmarine001 is a new contributor. Be nice, and check out our Code of Conduct.

 

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name Email

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsharepoint.stackexchange.com%2fquestions%2f250132%2fcalculated-column-if-and-question%23new-answer', 'question_page');

);

Post as a guest

Name Email

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name Email

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name Email

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name Email

Name Email

Name

Email

Name Email

Name

Email