Formula
Show any text when a statement condition is met. Let's break down the statement from the example above.
IF – the data function.
Sum – the name of the data lookup.
Sales – the name of the data source.
State="success" – filter. The filter includes the name of a data source field and the filtering condition. This formula will only sum the values from those registrations where the field's State values are "success." Filtering is case-sensitive.
Amount – the name of the field whose values will be summed.
50000 – target value.
Target Reached 🎉 – if the sum is greater than or equal to 50 000, the widget will display this message.
Working on it 💪 – if the sum is less than 50 000, the widget will display this message.
![](https://media.stonly.com/media/images/d9ded240-5b1b-4ce6-8a54-0b8dac77043c.png?s=d04a50ab8863cf3d0dfcda557d6046b0b9b80a5deb60bc2eb5b97a450cfe35a786a97c3d1527d498b60cc21938af7b098b7ead958e9e3839ccc1fccf79cf8630d3a79c90c7c0e4f3a731eec3fa853848d0c16cda1ffaff0d2bf1679c0ef7df90c5943d158d77cc4e2fa8aae3241dc471&w=1280&h=1440&auto=format)
Keeping a blank field
If you don't want to display a message when the target is not reached, you can leave empty quotation marks in the statement, like this: "Target Reached 🎉"," "
.
There needs to be a single space between the quotation marks – otherwise, the dashboard will show 0 instead of not showing anything.