Calculated Column Formula (Multiple Conditions)

(0) Share

Report

Posted on by krispag

I have a calculated Text column 'Status' in the PATROLS SharePoint list.

=IF(ISBLANK([Out of Service Date/Time]),"In Service","Out of Service")

The current formula, which is working, looks a singular column 'Out of Service Date/Time'. If that value is null, the Status value is "In Service" and if it is not null the Status value is "Out of Service".

I would like the formula to consider two date columns 'In Service Date/Time and 'Out of Service Date/Time'

If both of the aforementioned value are null, then 'Status' is "Scheduled"

If 'In Service Date/Time' is not null, but 'Out of Service Date/Time is null, then 'Status' is "In Service"

If both 'In Service Date/Time' and 'Out of Service Date/Time' are not null, then 'Status' is "Out of Service"

Thank you so much!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

SebS 4,582 Moderator on at

Like (0)

Report
@krispag

I'm not sure if that will work, but You can try to replace other with whatever You like:

=IF( AND(ISBLANK([In Service Date/Time]), ISBLANK([Out of Service Date/Time])), "Scheduled", IF( AND(NOT(ISBLANK([In Service Date/Time])), ISBLANK([Out of Service Date/Time])), "In Service", IF( AND(NOT(ISBLANK([In Service Date/Time])), NOT(ISBLANK([Out of Service Date/Time]))), "Out of Service", "Other" ) ) )

Was this reply helpful? Yes No
BhaskarDhone 1,392 Super User 2025 Season 2 on at

Like (0)

Report
try this something similar to this
=IF(AND(ISBLANK([In Service Date/Time]), ISBLANK([Out of Service Date/Time])), "Scheduled", IF(ISBLANK([Out of Service Date/Time]), "In Service", "Out of Service") )

Was this reply helpful? Yes No