Hey guys.
I’m creating an application to report the kilometers driven on my company’s car.
I have a spreadsheet called AGENDA where I make a list of tasks for the driver to complete.
From this list, he clicks on the route to start traveling.
To do this, I created an ACTION to place the data in the ROTAS spreadsheet. It is at this time that the driver needs to inform the vehicle’s initial kilometer before starting.
I want to open a pop-up for the driver to enter this information.
I tried to use INPUT(KmInicial_Input,“0”) but the pop-up is not opening for the driver to enter the correct data, the formula is throwing the number zero in the database.
I noticed that in the same spreadsheet, the INPUT() formula works normally. But when I want to enter data into another spreadsheet, the formula doesn’t work.
What is the way out of this?