View Single Post
 
Old 03-19-2020, 12:25 PM
jthomas666 jthomas666 is offline Windows 10 Office 2016
Competent Performer
 
Join Date: Jun 2016
Location: Warner Robins, GA
Posts: 204
jthomas666 will become famous soon enough
Default

OK, last question for at least a day or two.

We had to change the DueDate calculation from

Quote:
=IF(AND([Delivered]=0,[DueDate]>TODAY()),"",AND([Delivered]>0,[DueDate]>TODAY()))
to

Quote:
=IF(AND([Delivered]=0,[DueDate]>TODAY()),"",AND([Delivered]>0,[Delivered]<=[DueDate]))
I just pasted the new formula into the appropriate cells. When adding some records today, I noticed that the new records had the old formula, suggested that the formula is set as a default somewhere else. How do I change that default?

Again, I cannot tell you how much I appreciate your help. You'll be happy to know that I added several new DocClasses today without problem, so I'm making progress, slow as it is.

Thanks again.

Jim
Reply With Quote