gtech

Hi pat, I wrote some scripts, also based on your examples, one is disconnected from the worksheet, where it asks me with the message box to enter the data and then there is a pop up with the result. another one works with the subrows of the worksheet, reads the content and does the math and for each subrow, a popup returns with the result, but I have not found a function that writes the result in the subrows. Subrow Case.txt sorry but i'm not as clean as you are in scripting in the experimental phase. 😅

in E column=VALUE('Lighting Device'.'User Field 1'), but in the F formula, instead of reading the values from other cells, I take them directly, and so the E column is used to remind me the numbers in the user field. Knowing the number of fixtures used, knowing how many fixtures each box (Flycase) contains, I want to know how many boxes for each type of fixture I have to take from the warehouse.

Hi, you're right, I don't need the INT function. as you can see in the picture on F column, if I add "roundup" funcion, as result I have the COUNT in the second screenshot i tried to execute the functions separately, but the result of roundup is "quantity". To explain myself better I also copied the functions in the first line. In green color is what I would like to have, with excel it works. VW 2021 pc. Thanks!

Hi all, I’m learning to use Vw spotlight and I would like to create, in a datasheet, a column that divides the number of objects (COUNT) and a number contained in a user field. If I insert this function "=INT(COUNT)/VALUE('Lighting Device'. 'User Field 1')" in the line I get the right result, but if I try to round up the result "= ROUNDUP (INT (COUNT) / VALUE ('Lighting Device'. 'User Field 1'), 0)" the function doesn't work, I also tried alternative rounding methods but without success. I tried to write some scripts, but I can't find sufficient examples or explanations, what I need is to read the quantity of objects (same light device) and divide them using the number in user field 1, and then return the result in the subrow corresponding in datasheet. I wrote a script that counts the subrows, reads the contents of each subrow with the COUNT, divides it by the number of the subrow corresponding to the user field, rounds it and gives me the result as a popup, I have not found a function that allows me to write in a subrow. can anyone help me? maybe referring me to the resources where I can understand how to do it.