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

Break Up Multi-Entry Row
I'm using a form entry (into an Intake Sheet) in which someone can select multiple locations for the same Initiative. I'm looking to copy the row to a different Master sheet, but would like to have the same row copied multiple times, once per location selected. Intake Sheet: Desired Result in Master Sheet: Basically, I…
Set contents of two columns into 1
Hi - trying to figure out a formula that combines two columns into one long column, maintaining contents in multiple rows. Noting that the number of items in each column will change as these are each using the index/distinct to summarize a separate sheet. For example: Thanks for any help!
Unparsable formula; Sheet summary SUMIF formula
Can anyone help why this formula is coming up as unparseable? I'm creating a sheet summary, where it totals the Estimated GP (Est. GP) column if the Status column has the "Quoted" drop-down option is selected. Formula i've used: =SUMIF(Status:Status,"Quoted",Est. GP:Est. GP) Thanks a lot!