Hello great people:
How can I give a message in the tab if the balance of the records is offset, and if there are no records or at least 1 record in a tab, then the message would be "records are offset" in the following workflow?
Appreciate your help.
Thanks
Solved! Go to Solution.
goHey @Kinetic_analytics,
I would do something like this:
This sums up all balances and then checks if they are 0. If they are, the Tab is written with your Text, if your Balance is different it is now "Sheet 1" - but this can ofc. be changed aswell.
@FrederikE Thanks for your idea. But, I want to see the message on theme wise tab. For instance I have 20 different themes where the balance is 0 i want to see the message that tab. In any themes Not in a single sheet 1 tab. Hope it is bit clear.
@Kinetic_analytics - Can you give a visual of what you are wanting? Are you wanting to change the tab name from say "369" to "369 - Records Offset"?
Hey @Kinetic_analytics,
This works:
I use the "Action" Column as the grouping field for the individual tabs - this is prob. not what you want, but you can ofc exchange it to the correct one.
@FrederikE Thank you for your time and advice.