Forum Discussion
Adding a IF formula to an AND formula
Good morning.
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.
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.
Can anyone help me with this formula?
Thanks!
UPDATE: I am not sure if it matters, I wouldn't think that it would, but I am working out of Google sheets. Thanks!
2 Replies
Try something like this in G7: =if(G7=$E7,$D7,"")
then copy it to all the other cells in the calendar portion. It should add the project title to cell of the first day.
I received an error message: "Circular dependency detected."
