Forum Discussion

Greg-Growney's avatar
Greg-Growney
Copper Contributor
Feb 27, 2025

SharePoint List - 3 way IF statement

Hi, I have the following IF statement working returning statues based on the value of a calculated field 'Days to Test'. The days to test field calculates the number of days remaining compared to todays date. 

 

=IF([Days to Test]<0,"OUT OF TEST","")&IF([Days to Test]<=180,"CHECK TEST DATE","")&IF([Days to Test]>180,"CLEAR TO USE","")

 

Statement works fine, except if I have a value which is <0, It shows both OUT OF TEST and CHECK TEST DATE. 

 

Anyone have a solution to stop this from happening, so if the value is <0, it just feeds back OUT OF TEST?

 

 

Lists
SharePoint Online
  • Rob_Elliott's avatar
    Rob_Elliott
    Bronze Contributor
    Mar 07, 2025

    Your formula should be as follows:

    =IF([Days to Test] <0,"OUT OF TEST", IF(And([Days to Test]>0,[Days to Test]<=180),"CHECK TEST DATE", "CLEAR TO USE"))

     

    Rob
    Los Gallardos
    Microsoft Power Automate Community Super User.
    Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)

Resources