Hey All!
I am trying to check to ensure that all timesheets have a corresponding scheduling item but my FIND formula is only working half the time. Any help would be appreciated!
IF(FIND(Timesheet,{Scheduled Dates (from Task)})>0,"",“Missing!”)
Solved
FIND Formula not picking up all values
Best answer by kuovonne
You are doing your find on a lookup field. When there is more than one value in the lookup field, you need to convert it to a text string from a list.
Try this …
IF(
NOT(
FIND(Timesheet, {Scheduled Dates (from Task)} & "")
),
"Missing!"
)
+17You are doing your find on a lookup field. When there is more than one value in the lookup field, you need to convert it to a text string from a list.
Try this …
IF(
NOT(
FIND(Timesheet, {Scheduled Dates (from Task)} & "")
),
"Missing!"
)
kuovonne wrote:
You are doing your find on a lookup field. When there is more than one value in the lookup field, you need to convert it to a text string from a list.
Try this …
IF(
NOT(
FIND(Timesheet, {Scheduled Dates (from Task)} & "")
),
"Missing!"
)
You are a life saver thanks so much!!!
Reply
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.