I need help on writing the calculated field for below:
Example : i have appid and its has multiple status , in below example XYZ app id has Cancelled and TODO status , if it has Cancelled and TO DO i need to calculate it as "Not started"
|APPID | Status | Calculated filed
|XYZ |Cancelled| "Not Started"
|TO DO |
i tried in below way but its not working as expected
if contains ([APPID],'') and [status] in ('Cancelled','ToDO') then 'Not Started'
and calculated filed needs to be show single status.
You keep on changing your data 😀, now we are going back to the original formula that I proposed. In the future, please upload a mock data/model up front thus the forum will understand your structure from the beginning.
Take a look at below. Let me know if you have any question. If the solution helps, do mark it as best. Sample model attached.
