Forum Discussion

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 DAT...

Lists

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)