Good day,
My tracker of all tracker spreadsheets is almost complete.
I have established the formula for E2:
=IF((C2-NOW())<0,"OVERDUE",C2-NOW())
but now I would like to add the following:
once I send a report for signature, I like to enter "S20200410" in Column B showing S means sent and the date is yyyymmdd (just internal information)
when I enter that in B3, E3 populates with "SENT" and then when I get the report back, I enter my yyyymmdd date format and it reflects similar to row 2 and close out that row.
I have the following:
=IF(ISNUMBER(SEARCH("S",B3)), IF((C2-NOW())<0,"OVERDUE",C2-NOW())
Searching for "S" in B3 and if no S, then continue with the next If statement.
It just doesn't produce anything for me.
Thank you for your amazing help!
My tracker of all tracker spreadsheets is almost complete.
A | B | C | D | E | |
1 | NAME | LAST REPORT | NEXT REPORT | 30/60/90 | DAYS REMAINING |
2 | JOE | 20190611 | 20200609 | 60 DAYS | 35 |
3 | BILL | S20200410 | SENT |
I have established the formula for E2:
=IF((C2-NOW())<0,"OVERDUE",C2-NOW())
but now I would like to add the following:
once I send a report for signature, I like to enter "S20200410" in Column B showing S means sent and the date is yyyymmdd (just internal information)
when I enter that in B3, E3 populates with "SENT" and then when I get the report back, I enter my yyyymmdd date format and it reflects similar to row 2 and close out that row.
I have the following:
=IF(ISNUMBER(SEARCH("S",B3)), IF((C2-NOW())<0,"OVERDUE",C2-NOW())
Searching for "S" in B3 and if no S, then continue with the next If statement.
It just doesn't produce anything for me.
Thank you for your amazing help!