Share via

SharePoint List conditional formulas If

Chaitanya Kadam 0 Reputation points
2023-09-04T06:39:07.41+00:00

I am traying to SharePoint List conditional formulas Following Present column : =if([$Category] == 'Working', 'true', 'false') and Absent Column : =if([$Category] == 'Not Working','true','false') how to achieve this

Microsoft 365
Microsoft 365
Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.
4,363 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,300 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ling Zhou_MSFT 15,555 Reputation points Microsoft Vendor
    2023-09-06T06:14:30.84+00:00

    Hi @Chaitanya Kadam,

    Here I am using calculated column formulas. Hope it will be helpful for you.

    For Present column, please try this formula:

    =IF([Category]="Working", "true", "false")

    User's image

    For Absent column, please try this formula:

    =IF([Category]="Not working", "true", "false")

    enter image description here

    Here is the result in my test:

    User's image

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.