Forum Discussion
Help with an excel formula
Hello, I am writing a formula for table from column A to Column U. (In the dutch version so I translated the formula from dutch to english). The Formula is located in A4 Column A is called...
=IF(T4=TRUE,"canceled",IF(R4=TRUE,"complete",IF(L4=TRUE,"process finished",IF(AND(J4<>"",J4<=TODAY()),"in process",IF(AND(J4<>"",J4>TODAY()),"assigned",IF(J4="","not assigned",""))))))You can try this formula which seems to work in my sheet if i correctly understand what you want to do.
=IF(T4=TRUE,"canceled",IF(R4=TRUE,"complete",IF(L4=TRUE,"process finished",IF(AND(J4<>"",J4<=TODAY()),"in process",IF(AND(J4<>"",J4>TODAY()),"assigned",IF(J4="","not assigned",""))))))You can try this formula which seems to work in my sheet if i correctly understand what you want to do.
- It is almost what I want I translated it backl to dutch and needed to change two things the <Today and the >Today they needed to be reversed.
=IF(T4=TRUE,"canceled",IF(R4=TRUE,"complete",IF(L4=TRUE,"process finished",IF(AND(J4<>"",J4>=TODAY()),"in process",IF(AND(J4<>"",J4<TODAY()),"assigned",IF(J4="","not assigned",""))))))
Now I got one more challenge, when I put in a date beyond the current dat in J4, so for example Today it is the 19-04-2022 when i entered that it says "In Process" which is good but when a project is planned on the 20-04-2022 after the current date it also states "In process" but it must have the "Assigned" status and tommorow when I open the excel it is changed to "In process" because of the date change. Is there a way that could be implemented?I don't understand why you have changed the suggested formula.
The formula returns "Assigned" if the date is in the future. In the attached file the date in cell J5 is "19.05.2022" and the formula returns "Assigned" as intended. On the 19th of may 2022 the formula returns "in process" in cell A5. In cell J9 the date is "11.03.2022" and the formula returns "in process" in cell A9 as intended.
If you want these results you can simply implement the suggested formula.
- In the dutch version it didn't, don't know why but after reentering it it works!!! thanks
