Get Cell in Spreadsheet

[Mayank]

I am using Spreadsheet Component in which i have many rows filled with details

Eg like this

So in my app if i searched something and if that is present in it then add “Yes” in the cell in front of them.

Here.

Pls help if Possible

Thank You

[iaditya_nanda]

@Mayank what have you tried so far?
you can try this:
→ Get Column → if item present → get the index of the item → update the cell simple

[Mayank]

Can u provide a visual representation .

I havent tried anything as i am not understanding how to start or what to do

[iaditya_nanda]

@Mayank Try this:
→ This is a simple example only rest try on you own first…

[Mayank]

Its coming Failed

pls help

thank you

[iaditya_nanda]

Cause you must have done something wrong. is the API endpoint correct?

[Mayank]

Currently the get column function is working but the update function is not working pls help

thank you

[iaditya_nanda]

what error are you getting? like did you tried to do manual testing?

[Mayank]

This is somewhat working but the problem is, it is updating the cell above the required cell

what changes should i make?

[BharatTech]

Spreadsheet1 UpdateData>>>rowNumber>>>global index+1

[Mayank]

Thank You So Much