Populate a drop down based on date in other columns
Is it possible to auto-populate a drop down based on a date being entered over a range of columns?
Column 1 (Drop Down) Pending (Date) Review (Date) Released (Date)
Review 2/12/19 2/19/19
Released 2/12/19 2/19/19 2/21/19
So what I am looking for is if there is only a date in Pending, then Pending would be chosen from the drop down. But if there is a date in Pending and Review, then Review would be chosen from the drop down. And lastly, if there is a date in all three columns, then Released would be chosen from the drop down. Is this possible?
Help Article Resources
Check out the Formula Handbook template!