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.
3,732 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,559 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Ling Zhou_MSFT 12,955 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.