Forum Discussion

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

Sharepoint List - IF Statements

Hi All,

 

I have a the following formula in a list column outputting a value based on another field 'Days to Test'.

 

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

 

Only issue I am having is if a value is <0, it is returning 'OUT OF TESTCHECK TEST DATE'.

 

What do I need to do to this formula so it it only return OUT OF TEST if the value is <0. And to return CHECK TEST DATE if the value is <180 but >0?

 

Thanks

Lists
  • 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