Automatically enter certain Text in a cell if Date Open > 60 days
I currently have 2 formulas that work in conjunction to look at Acct Open Date and if it's greater than 60 days it populates a column/cell with yes or no (via checkbox) then, looks to a SECOND column/cell and tells the first cell to enter the text that is in the reference cell. It works fine but it relies on me copying and pasting the Text in the reference cell down a bunch of rows ever so often. SURELY there is a better way to do this now since I set it up a few years ago. I can get the auto populate formula tool to work but my system still relies on me dragging down and copying the reference text...sigh...I attached a screen shot
Help Article Resources
Check out the Formula Handbook template!