I have attached an example of the worksheet I am working on. I am looking for a way to make my "second call/email" column to either show blank or an "N/A" if my "follow up needed" column shows "no" and I want it to populate the "second call/email" and "last follow up date" columns when it shows "yes".
The top table is what I have the bottom table is what I want it to be without the proper function to make it so.
Maybe this formula in the second call/email column..
Formula:
Please Login or Register to view this content.
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
Pretty much the same...
K3=IF(J3="yes",WORKDAY(H3,2),"")
Note that the YES in J5 has a trailing space, so the formula will not see that as a "yes". Consider fixing it?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks