Apr 03 2019 06:04 PM
I am trying to create a simple way of showing availability for a form. The codes represent times and dates before and after the event. For example:
"-4d" = 4 Days before the event available during the day
"-2e" = 2 Days before the event available during the evening
In a single column the database exports all their availability into one cell. Example:
-4d, -6d, -1d, -5d, 0d, -1e, -5e, -6e, 2d, 5d, -3d, 3d, 8d, 3e, 0e, -4e, -2d, -2e, 1e, 1d, 2e, -3e, 8e, 6d, 6e
Now in the column labeled "-4d", I want to take the one part of the value (ie "-4d") and show that they are available that day and instead of the result being a "1", I want it to return the result as "Yes". And if they on a day like "-1d" it would leave a separate column empty because there is no returned value.
Here is the line I came up with, but it is not working. Please help:
=FIND("-4d",H2)=AND=IF(F2="1","Yes","No")
Apr 03 2019 06:38 PM
SolutionI figured it out, so I thought I would share in case anyone else is looking for this:
=IF(ISNUMBER(FIND("-6d",AJ3)),"Yes","No")
That fixed the problem and did what I needed.
Apr 03 2019 06:38 PM
SolutionI figured it out, so I thought I would share in case anyone else is looking for this:
=IF(ISNUMBER(FIND("-6d",AJ3)),"Yes","No")
That fixed the problem and did what I needed.