Recent content by stefanocps

come on..this is not the point, there are some need that must be accomplished

it is too complicated..this must be used from operator..they just need to fill the questionnaire, and when they need go to the sheet and make their filtering to get datas they want

the sheet is in progress..that module is a quetionnaire that will be updated daily moe or less..

but i don't have a clue of java script though don't understand the way to copy the formula..manually everytime??

https://docs.google.com/spreadsheets/d/1idJPjUn3yTjMO742ft7r4jLFiBCp-tsLvXEM_hnFiXQ/edit?usp=drive_link

sheet is editable..module you don't need..tjhis is just a small sample

i don't understand what you are telling me What you mean "what has been entered"? The data from module? if you see the second sheet the column D and F have formulas realted to what user input in questionnaire. I needthe second sheet to peform this formulas

this is the module https://docs.google.com/forms/d/e/1FAIpQLSelSkCxfAsYjWS1KQV01ApGTQA3RxddP6uOfEUHb6GWZlYc5Q/viewform?usp=sharing this is the sheet

this is what i am doing in sheet 1 there are all data coming from he module In sheet 2 i reference some of those data i need for calculation and make the calculation The prblem is that when i insert a new record, the formula jump..if i am at c2..the new record will make jump the formula to...

don't understand..the formula dont work because a record from google form is inserted..otherwise it would work..don't understand what shall i do meanwhile i might have done a step hade using this =INDIRECT("modulo!$C2") works But in this way i cannot drag down the formula because all the cell...

don't work..the formula sheet..if i drag it later datas come out..but when i insert a record this spoil the formulas i use this formula now =modulo!$C2 if i put $ before sheet i get error..what operator should i use befor? = don't work, don't undertnd if you put some symbol before but it don't...

i have gone ahead..you did not read my next posts!i have a problem with assigning value in the sheet now

i have tried to use another sheet for conditional value..in this second sheet i fetch data from first sheet, and add the cell with logic. But everytime i add a record..the formula change so if i have in first row =SHEET1!A2 when i add a new record the next ecord becom SHEET1!A4 every tme i add...

ok i am getting ahead. i have aproblem i have linked my form , now with just name and a question with yes/no answer It goes correctly to a sheet. In another cell, i have set the forumla to place a value according the the answer So if B2 contain YES B2 is E, if B2 contain NO B3 is NE. And it...

i never used google sheet or form ..normally do it with excel access..but i need this datas to be available online to be shared..so i use google can you give me som emore hint on how to proceed? thanks