Forum Discussion
Multiple (I think) IF formulas in one cell.
Hi.
I'm trying to build semi-automated worksheet that depending on IF there is a date in particular column(s) then provide specific value. Dedicated cell is now "Conditioned" to look for 4 words (Requested, Received, Started and Completed). Each of these words have separate colour. What I'm trying to achieve is to have 4 additional columns with Date Entered, Date Received, Date Started and (Date Completed + Operator). So, IF we just have a date in the ENTERED then the cell will give result value as "Requested". What I want to achieve then is to have that + if date in "Date Received" cell then override value "Requested" with value "Received" and so forth until I have last expected value that depends on all previous cells being populated plus another 2 "Date Completed + Operator" to give me value of "Completed".
Is this possible?
2 Replies
Let's say Date Entered is in column D, Date Received in column E, Date Started in column F and (Date Completed + Operator) in column G, starting in row 2.
Enter the following formula where you want to see the status:
=IFS(G2<>"", "Completed", F2<>"", "Started", E2<>"", "Received", D2<>", "Requested", TRUE, "")
Fill down.
HansVogelaar Thank you!! Works just like I wanted it to!! 🙂 Have a great weekend!! 🙂
