Forum Discussion
jteeter18
Jun 29, 2022Copper Contributor
Getting a date formula to change once data is input into another cell
I would like cell O4 (Due Date) which includes a formula to check whether a cell A4 (Client List) is either blank (then O4 stays blank), or if it is a certain client or not. If A4 is a certain client...
HansVogelaar
Jun 29, 2022MVP
=IF(A4="","",IF(A4="client 1",IF(R4="",'sheet 2'!C3,'sheet 2'!E20),IF(R4="",'sheet 2'!C5,'sheet 2'!E21)))