Choose Language Hide Translation Bar
stvwllc76
Community Trekker

Updated row state

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?

0 Kudos
2 REPLIES 2
ms
Super User ms
Super User

Re: Updated row state

Try this:

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

0 Kudos
stvwllc76
Community Trekker

Re: Updated row state

That did it.  Thanks!

0 Kudos