Skip to main content
SharePoint

Return to Question

added 4 characters in body; edited tags
Source Link
Ganesh Sanap - MVP
Ganesh Sanap - MVP
  • 46.4k
  • 22
  • 31
  • 63

I am trying to create a calculated column with multiple conditions.

So, the Application “Status” is “Over Due”, if the Stages column is still “Stage 1” and the “Days since Application” is 5 days or greater.

If the Stages field is “Stage 2 or more” it will be on “On Track”. What is the formula to put in SharePoint lists to create “Application Status”?

The current formula below is not working

=IF([Days since Application]>5,IF(Stages="STAGE 1","OVERDUE","ON TRACK"))
Stages Days since Application Application Status
Stage 1 4 On Track
Stage 1 6 Overdue
Stage 2 7 On Track

I am trying to create a calculated column with multiple conditions.

So, the Application “Status” is “Over Due”, if the Stages column is still “Stage 1” and the “Days since Application” is 5 days or greater.

If the Stages field is “Stage 2 or more” it will be on “On Track”. What is the formula to put in SharePoint lists to create “Application Status”?

The current formula below is not working

=IF([Days since Application]>5,IF(Stages="STAGE 1","OVERDUE","ON TRACK"))
Stages Days since Application Application Status
Stage 1 4 On Track
Stage 1 6 Overdue
Stage 2 7 On Track

I am trying to create a calculated column with multiple conditions.

So, the Application “Status” is “Over Due”, if the Stages column is still “Stage 1” and the “Days since Application” is 5 days or greater.

If the Stages field is “Stage 2 or more” it will be on “On Track”. What is the formula to put in SharePoint lists to create “Application Status”?

The current formula below is not working

=IF([Days since Application]>5,IF(Stages="STAGE 1","OVERDUE","ON TRACK"))
Stages Days since Application Application Status
Stage 1 4 On Track
Stage 1 6 Overdue
Stage 2 7 On Track
added 2 characters in body
Source Link
Christoffer
Christoffer
  • 9.9k
  • 3
  • 37
  • 53

I am trying to create a calculated column with multiple conditions.

So, the Application “Status”“Status” is “Over Due”, if the Stages column is still “Stage 1” and the “Days since Application” is 5 days or greater.

If the Stages field is “Stage 2 or more” it will be on “On Track”. What is the formula to put in SharePoint lists to create “Application Status”?

The current formula below is not working

=IF([Days since Application]>5,IF(Stages="STAGE 1","OVERDUE","ON TRACK"))
Stages Days since Application Application Status
Stage 1 4 On Track
Stage 1 6 Overdue
Stage 2 7 On Track

I am trying to create a calculated column with multiple conditions.

So, the Application “Status” is “Over Due”, if the Stages column is still “Stage 1” and the “Days since Application” is 5 days or greater.

If the Stages field is “Stage 2 or more” it will be on “On Track”. What is the formula to put in SharePoint lists to create “Application Status”?

The current formula below is not working

=IF([Days since Application]>5,IF(Stages="STAGE 1","OVERDUE","ON TRACK"))
Stages Days since Application Application Status
Stage 1 4 On Track
Stage 1 6 Overdue
Stage 2 7 On Track

I am trying to create a calculated column with multiple conditions.

So, the Application “Status” is “Over Due”, if the Stages column is still “Stage 1” and the “Days since Application” is 5 days or greater.

If the Stages field is “Stage 2 or more” it will be on “On Track”. What is the formula to put in SharePoint lists to create “Application Status”?

The current formula below is not working

=IF([Days since Application]>5,IF(Stages="STAGE 1","OVERDUE","ON TRACK"))
Stages Days since Application Application Status
Stage 1 4 On Track
Stage 1 6 Overdue
Stage 2 7 On Track
deleted 22 characters in body; edited tags
Source Link
Christoffer
Christoffer
  • 9.9k
  • 3
  • 37
  • 53

Hi there and thanks for any help given. I am trying to create a calculated column with multiple conditions.

So, the Application “Status” is “Over Due”“Over Due”, if the Stages column is still “Stage 1”“Stage 1” and the “Days since Application”“Days since Application” is 5 days or greater.

If the Stages field is “Stage 2 or more”“Stage 2 or more” it will be on “On TracK”“On Track”. What is the formula to put in SharePoint lists to create “Application Status”“Application Status”?

The current formula below is not working =IF([Days since Application]>5,IF(Stages="STAGE 1","OVERDUE","ON TRACK"))

=IF([Days since Application]>5,IF(Stages="STAGE 1","OVERDUE","ON TRACK"))
Stages Days since Application Application Status
Stage 1 4 On Track
Stage 1 6 Overdue
Stage 2 7 On Track

Hi there and thanks for any help given. I am trying to create a calculated column with multiple conditions.

So, the Application “Status” is “Over Due”, if the Stages column is still “Stage 1” and the “Days since Application” is 5 days or greater.

If the Stages field is “Stage 2 or more” it will be on “On TracK”. What is the formula to put in SharePoint lists to create “Application Status”?

The current formula below is not working =IF([Days since Application]>5,IF(Stages="STAGE 1","OVERDUE","ON TRACK"))

Stages Days since Application Application Status
Stage 1 4 On Track
Stage 1 6 Overdue
Stage 2 7 On Track

I am trying to create a calculated column with multiple conditions.

So, the Application “Status” is “Over Due”, if the Stages column is still “Stage 1” and the “Days since Application” is 5 days or greater.

If the Stages field is “Stage 2 or more” it will be on “On Track”. What is the formula to put in SharePoint lists to create “Application Status”?

The current formula below is not working

=IF([Days since Application]>5,IF(Stages="STAGE 1","OVERDUE","ON TRACK"))
Stages Days since Application Application Status
Stage 1 4 On Track
Stage 1 6 Overdue
Stage 2 7 On Track
Source Link
DAz
DAz
  • 1