Adding a IF formula to an AND formula

Question

Good morning.&nbsp;&nbsp;I am trying to set up a project calendar for my marketing department and found that using conditional formatting was the best way to do it for what we need instead of using a Gantt chart.&nbsp;&nbsp;The issue I am having now is I want to add the project name to the bars that appear in the calendar portion (see image attached). I can not seem to figure out what the formula would be to get for example '- Winter Summit' to appear in cell G7.&nbsp;&nbsp;Can anyone help me with this formula?&nbsp;Thanks!&nbsp;&nbsp;UPDATE: I am not sure if it matters, I wouldn't think that it would, but I am working out of Google sheets. Thanks!

philip west · Answer

Try something like this in G7: =if(G7=$E7,$D7,"")&nbsp;then copy it to all the other cells in the calendar portion. It should add the project title to cell of the first day.

sross · Answer

I received an error message: "Circular dependency detected."&nbsp;&nbsp;

Forum Discussion

Adding a IF formula to an AND formula

2 Replies