Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
share point online list formula to automate project status RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Please i need help. I need a formula on share-point online list.

    I have 3 columns namely:

    Child care status, Education status, Micro business status.

    Each of the columns above have (Completed, Initiated, Approved, Partially completed) as their drop down options.

    I intend to create a calculated field(Finalstatus) that returns

    Completed   (If any  of the 3 columns reads "completed")
    Initiated     (If any of the 3 columns reads "Initiated")
    partially completed (If any of the 3 columns reads "Partially completed)
    Approved    (If any of the 3 columns reads "Approved")

    Please consider ISBLANK for null values.

    Please i crave your indulgence to please share your ideas as to how i can get this done.

    • Moved by Dave PatrickMVP Thursday, September 3, 2020 1:22 AM looking for forum
    Wednesday, September 2, 2020 10:03 PM

Answers

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    I'd try asking for help over here.

    https://docs.microsoft.com/en-us/answers/topics/office-sharepoint-online.html

     

     


    Regards, Dave Patrick ....
    Microsoft Certified Professional
    Microsoft MVP [Windows Server] Datacenter Management

    Disclaimer: This posting is provided "AS IS" with no warranties or guarantees, and confers no rights.

    • Proposed as answer by Guido Franzke Thursday, September 3, 2020 6:39 AM
    • Marked as answer by Dave PatrickMVP Tuesday, September 8, 2020 1:14 PM
    Thursday, September 3, 2020 1:21 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Thanks Dave..Will  be expecting any reasonable support.

    Thanks a lot

    Thursday, September 3, 2020 5:55 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    You're welcome.

     

     


    Regards, Dave Patrick ....
    Microsoft Certified Professional
    Microsoft MVP [Windows Server] Datacenter Management

    Disclaimer: This posting is provided "AS IS" with no warranties or guarantees, and confers no rights.

    Thursday, September 3, 2020 12:27 PM