I have reduced to this simple code an unexpected behavior in a larger python code:

I am new to function and I am looking for some help understand how to make a function that will work under the Zoho sites.

What’s wrong with this code? I have declare the Tiktok but the when I run this code, the Tiktok didn’t read as a function

Closed 3 hours ago.

enter image description hereI have peoples names in the columns under each name is rows with the week and then a number under each column name, I want to find a formula that can auto calculate the top 3 names of the values for a specific week I select, any ideas woukd be greatly appreciated.

enter image description hereI have peoples names in the columns under each name is rows with the week and then a number under each column name, I want to find a formula that can auto calculate the top 3 names of the values for a specific week I select, any ideas woukd be greatly appreciated.

I am learning python and just got to ‘Def’ function. When I try to run the code I keep getting this error and I don’t know what to do. I have tried reinstalling all the extentions, Reinstalled VScode, but it still gives me this error. Could anyone help?

I have a file in which I have around 50 sheets with extensive data in each sheet.
I made a list of all the sheet names so that I can create a tabular data of all sheets’ data using indirect address function. I have given the reference sheet names from the list of the sheets in my indirect address function. in Column A, I have listed all the sheets’ names. In rest columns I have Indirect function in which, I have formula like this:- =@INDIRECT(ADDRESS(B$3,B$4,1,,$A7)). In B3.B4 I have the row & column numbers and in A7 I have sheet name. so on….. It is working fine and I am getting dynamic data from each sheet in this single sheet.