Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Mar 30, 2023 03:05 AM - edited Mar 30, 2023 03:07 AM
Hello,
I have a table with fields like this :
The "First char" field is a formula that return the first character UPPER of the "First name" field.
Then, the field "check" is used to filter a view from A to E. So i need a formula that show "OK" if the "First char" field contain A or B or C,,,,,,,,,E or else it will show "KO"
Any ideas how to do it ?
Thanks.
Solved! Go to Solution.
Mar 30, 2023 03:10 PM
try this formula:
Mar 30, 2023 03:10 PM
try this formula:
Apr 03, 2023 05:34 AM
Thank you so much !
Yes ! this solve my problem. And this formula works.