ABHI✭

Thanks @Leibel S It worked like a champs.

=INDEX(COLLECT({Fire Extinguisher & Eye Wash Inspection Range 1}, {Fire Extinguisher & Eye Wash Inspection Range 2}, [Tracking No]@row), 1) I have used above formula which works fine for the cell that has exact match but there are some cells that doesnot have exact match. I am trying to see if I can use collect and…

Hi @David Joyeuse Thank you. That worked

Here, I wanted to check if the equipment match with other Sheet and check if PM scheduled has "YES" if that conditions is fulfilled then I want to pull WORK ORDER No. from the second sheet to the first sheet.

Thank you for the help Mike. But I am trying to get values from another sheet and from the same rows not from column. How can we write the formula? Can you give me some examples?

You can use: Countifs({column_in_anothersheet},FIND("Dropdownlist_word", @cell) > 0) This will give you the count in that column.

yes i have. But how can I use reports in my dashboard?

Thank you Guys.

I tried using Zapier but how? Zapier wants me to buy timecap app as well. Azuqua seems pretty promising but my company doesn't want it since they think it might compromise the security.

Thank you Very Much. I was stressing it over more than 3 hours.