It's a long formula - I want to make the number of starts in the "Current Status" column dependent upon the selection in the drop down from the "Contract/Grant Status" column:
=IF([Contract/Grant Status:]1 = Submitted, "Empty", IF([Contract/Grant Status:]1 = Assigned, "One", IF([Contract/Grant Status:]1 = ELD Review ODE Draft, "Two", IF([Contract/Grant Status:]1 = To DOJ, "Three", IF([Contract/Grant Status:]1 = Out for Signatures, "Four", IF([Contract/Grant Status:]1 = Executed, "Five" ))))))
Thoughts anyone? Thanks! Teresa