Added True/False formula to Large sheet & now have multiple proble

J

JJM810

Last week I added a true/false formula to show if work was completed within
time frame and first the task bar was not calculating. I saw someone else
had a fix for that which worked if I do it every day. Now it is not pulling
up the correct items in searches, and has one column with dates displayed in
different formats & I can't get it to go back to default. Some are 3/9/2006
and some are 3/9/06. It may not be able to find the correct data because the
dates are messed up but I can't fix it. I assume it just has too many
calculations, but if I delete my formula, it still does not improve.
 
J

JJM810

Also forgot to note that the column that has the incorrectly formatted dates
also shows an auto filter arrow that I can't get rid of. If you do click on
it, nothing happens.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top