## Updated row state

Community Trekker

Joined:

Nov 19, 2012

I am trying to write a formula that returns a "yes" or "no" into a column depending on whether the row is excluded or not.  So far I have the following formula:

If( Excluded( Empty() ), "Yes", "No").  This returns the proper value, but I cannot seem to get the column to automatically change from "Yes" to "No" if I change the row state from excluded to included or visa-versa.  Any suggestions for me?

2 REPLIES

Super User

Joined:

Jun 23, 2011

Try this:

If( Excluded( Row State( Row() ) ), "Yes", "No")

Community Trekker

Joined:

Nov 19, 2012

That did it.  Thanks!