I'm trying to extract a date into a formula date field from a logged field that isn't necessarily on the top or bottom of the log. It could be, but it could also be in the middle.
I need the date associated with the "living with" selection from a multiple choice field.
The formula i thought was working is
If(Contains([Type Log],"Living with"),
ToDate(Left(Right(NotRight([Type Log],"Living with"),"["),9)),null)
But then i realized if there was another entry below the "living with" entry, it was grabbing that date instead.
Is this possible?
Thanks!
------------------------------
Trish Wehrle
------------------------------
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.