Formula not coming while renegrating table from ex...

CA_Ankur_Patida · 11-01-2020 10:07 AM

I have used this formula in my excel which is performing there but when i restructured this table in appsheet its not working nor it is showing any bug.

Please help.

Steve

What is not working where?

You’ll need to fix the spreadsheet formula before considering any problem with your app.

CA_Ankur_Patida

See in K2 i have used one formula that is the combination of vlook up function and match function… its returning correct values in excel as shown in the screen shot but its not showing in appsheet table.

Steve

Fix the formula errors, then see if the app starts working.

CA_Ankur_Patida

How should i fix… see its already working in excel but when i regenerated this in appsheet its not working nor its showing any error.

How to overcome this??

CA_Ankur_Patida

Hey Steve,

First of all a big thank to you for your support.

Need your help as i got stuck somewhere.

As you can see in first screenshot that is the sheet 1 named as “Employee List” and second screenshot that is the sheet 2 named as “SLSK Attendance”. Unique ID D in sheet 1 and Unique ID in sheet 2 will be the matching field.

Now what i want is formula so that [Status] column in sheet 1 i.e the last column get filled with the current status of the employee that will be catched from the sheet 2.

For Eg:(If K2 of sheet 1 need to be filled)
It will run like …
It should search [Name] column field “Rameshwer verma” of sheet 1 in columns of sheet 2 and then return the value of row having common matching field i.e Unique ID D & Unique ID.

Can you please get me with the formula for this.

Thank you.

Steve

I’m afraid I cannot help with spreadsheet formulas.

Phil

When you do the regenerate are you seeing any errors or warnings about “mismatched formulas”?
See https://help.appsheet.com/en/articles/3326638-mismatched-spreadsheet-formulas

Formula not coming while renegrating table from excel