Nested IFS Statement to Determine Status
I use an Excel workbook (365 desktop) to track the status of correspondence that needs to hit various checkpoints (columns E, G, H, I (conditional), K). As the item moves through the process, dates are input into those respective columns; plus the occasional cancellation or item hold.
I am looking to build out Column M to provide an 'automated' location status that will change as dates or other key text are put into the columns mentioned above. I aim to be able to sort and count the correspondence by location/status.
My initial thought is to use a IFS statement to check for keywords or date by column precedence. I came up with the below but it is throwing an error.
Any help would be greatly appreciated.
Draft Formula - Throws #Name Error / [Top row below header is row 10]
=IFS(K10="Cancelled","Cancelled",K10="Hold","Hold",K10="Shutdown","Shutdown",ISDATE(K10),"Completed",ISDATE(I10),"TEXT5",ISDATE(H10),"TEXT6",ISDATE(E10),"TEXT7",ISBLANK(E10),"TEXT8")
Note: The snip shows a few of the different setups for the data rows.
[link] [comments]
Want to read more?
Check out the full article on the original site