Nested IF(ISBLANK & Date Columns w/Progress Bar

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:)

Automate - Progress Bar.png

Find more posts tagged with

Sales

Sheets

Hospitality

Healthcare

Formulas

Reports

Services

Support

Product Development

Project Management

Comments

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.

Sign in to join the conversation!

Quick Links

Trending discussions

Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?
Need Help with If, Index, Collect
Please help, I have a few of these to do. I have a nested IF formula. The first part is an INDEX/MATCH and works as a standalone. The next few are INDEX/COLLECT. These are not working as standalone or in the nested version (Unparsable Error). Any ideas? =IF(CONTAINS(“A/V”, [Vendor Type]@row ), INDEX(COLLECT({Date Secured…