I'm creating a tracker and would like the "Current end date" to stop when a condition.

I'm creating a tracker and would like the "Current end date" to stop when a condition is met.

Hello! First post here.

I have certain things running through a fabrication unit and made an excel spreadsheet to track it.

I am pulling data from an SQL Serve Database (learning as I go)

I would like the "Current end date" column to give me the date when:

(Current fab step + Current TDI step) = (Total fab steps + Total TDI steps)

Attached is a screenshotAttachment 715066

So if for example (Current fab step + current TDI step) = (Total fab steps + Total TDI steps) happened yesterday, I would like it to give me yesterday's date.

Since I have you here, in the database - Part numbers can show up multiple times. What function can I use to "skip a row and find the next one if the row has a 0 in it"?


Any information would be greatly appreciated!

Thanks!

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook.