Is there anyway to color cards based on the parent task? I can't seem to do this in conditional formatting and was hoping to find another way.
It isn't the cleanest solution probably, but you could just add an additional column to your sheet that gets set to the name of the parent task for every row (using the new PARENT() function). Now you'll be able to use conditional formatting based on the value of this column. Once everything is set up, you can hide the column and everything should be good!
Hi Greg
Thanks for the response. I had done what you suggested but without the Parent() function. That's a bit cleaner then my workaround!
Thanks for mentioning it exists. I appreciate it.
