If Statement Comparing Date of Text Entry Between Columns
We work from a running tracker were there are a series of dates (entered as text, not an actual date) are entered into different columns to signify when certain steps have been completed. I am trying to find a way to automate a flag or alert or something to designate how many days go between each step so we can easily see where the process is getting hung up. I know I can go in and view cell history to see when things are entered but I need a way to automate that. I'm currently thinking of two options, preference being option 2 if it's possible.
1) create some sort of IF statement comparing date of entry between two columns that outputs a flag or alert if more than a set time goes by from entry in the first column before something is entered into the second column.
1.1) a formula that flags or alerts automatically three days after entry into the first column. I could make this work though it is less desirable.
2) create a formula to read when the initial entry is entered into the first column compared against when something is entered into the second column. Here, we are more interested in how long it is taking from something being entered and that line being addressed (something entered into the second column) If there is a formula to call out how many days have passed I think it would solve my need to identify bottlenecks perfectly.
Help Article Resources
Check out the Formula Handbook template!