Hi there,
I´m trying to figure out a way to have a formula that update the status of one row line (from "overdue" to "completed") based in a new entry, sending an example below.
I´m trying to figure out a way to have a formula that update the status of one row line (from "overdue" to "completed") based in a new entry, sending an example below.
Activity | Last Date | Next Date | Status |
A | 01/01/2022 | 31/01/2022 | Overdue |
B | 10/02/2022 | 12/03/2022 | |
C | 05/05/2022 | 04/06/2022 | |
D | 02/06/2022 | 02/07/2022 | |
A | 31/01/2022 | 02/03/2022 |