Forum Discussion
Status Change based on dates
I have a Share Point Online list which has employee details.
An employee can work on 3 different projects at any given time. I need to be able to add a status column for their contracts. Test cases
| Start Date | End Date | Start Date | End Date | Start Date | End Date | Contract Status | |
| Jane Doe | 3/26/2015 | 12/31/2026 | 8/27/2021 | 12/31/2024 | 1/5/2022 | 1/5/2023 | Active |
| John Doe | 5/14/2012 | 9/30/2019 | 8/1/2017 | 8/26/2020 | 10/1/2019 | 10/1/2022 | Expired |
The contract status can be one of these choices: ACTIVE OR EXPIRED
nniphadk Try using below formula for your calculated column (status):
=IF(AND([End Date 1] > Today(), [End Date 2] > Today(), [End Date 3] > Today()), "Expired", "Active")OR
=IF(AND([End Date 1] > Now(), [End Date 2] > Now(), [End Date 3] > Now()), "Expired", "Active")Documentation: Calculated Field Formula
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
nniphadk I don't think you finished your post. What is your question, what outcome are you expecting and what have you tried so far?
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
