automated final status based on inout from other columns RRS feed

  • Question

  • 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 12:25 AM looking for forum
    Wednesday, September 2, 2020 10:46 PM