Help

FIND Formula not picking up all values

Topic Labels: Formulas
Solved
Jump to Solution
1331 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Corrine_Yeager
4 - Data Explorer
4 - Data Explorer

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!”)

image

1 Solution

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

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!"
)

See Solution in Thread

2 Replies 2
kuovonne
18 - Pluto
18 - Pluto

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!!!