What are some of the best ways you have found to indicate the data displayed on dashboards is still moving and not finalized yet? Are there any suggested methods other than creating a module that acts as a tracker and publishing it to the top of each dashboard that can visually call out that the final numbers are not ready yet?
There are a few ways to accomplish your request. For ease of reference, I created a module and provided some examples. My guess is you probably tried to use the FIND function. The FIND function works with text formatted strings. The "@" symbol isn't a text formatted string within the Text Formatted Property (Text: Email). The text characters for the "@" symbol is really "%40".
In Option 1, I've shown you a drawn out way to accomplish so you can see the step-by-step process. The 'Conditional Logic' line item shows you how to do it in one step.
In Option 2, I've shown how to do it with the COMPARE functionality. In the 'Compare' line item, it shows a "-1" where the Email Address doesn't equal the 'Domain' line item.
Option 3 represents loading the Email Address as a Text:General formatted item, converting it to a Text: Email formatted item for different usage, and then determining what email is invalid by using the Text:General formatted line item.
I hope this helps you determine the best way to accomplish for your particular example.