Skip to main content

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



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


Terms & Conditions