Nested IF(ISBLANK & Date Columns w/Progress Bar

lisarae723

Hi Everyone!

I would like to know if you are able to use date columns when automating a progress bar.  Basically dates are entered as product moves to a new stage in the process. As the dates fill in, the progress bar fills as well. I've used nested IF formulas for automating a progress bar but, for whatever reason... Im getting errors.

Been working on this for hours. I've attached a screenshot, if it helps. I am at a loss:)

 

 

Brian W

How are you calculating your progress? Are there four dates and the status should increase 25% each time a date is entered? If that's the case you could use a formula like this:

=IF(ISDATE([Received at Brady]@row), "Full", IF(ISDATE([Shipped TLP]@row), "Three Quarter", IF(ISDATE([In Testing TLP]@row), "Half", IF(ISDATE([On Press TLP]@row), "Quarter", "Empty"))))

lisarae723

Thank you Brian! It works!! This looks the way I had it set up at one point but, I realized that on of my column names had an extra space in it... throwing the whole thing off. I am so appreciative...thanks again.