Forum Discussion
samuel afroman
Feb 15, 2018Copper Contributor
I have a nesting formula I am trying to restrict the out put by todays date -7
=IF(E2=1, "letter 2", IF(E2=2,"letter 3", IF(E2=3, "call", "nothing issued")))
The above gives me the correct output necessary for determining which letter I next need to issue, however, I would li...
SergeiBaklan
Feb 15, 2018Diamond Contributor
One more IF on the top
=IF(E3=TODAY()-7,IF(E2=1, "letter 2", IF(E2=2,"letter 3", IF(E2=3, "call", "nothing issued"))),"")