What is the difference between dereference and lookup()? Both seems to find the references row to pull column value from another table. Thank you!

I am trying to built a task generator where there is an existing list of task and the user inputs their free time and the app spits out a tasks that can be accomplished within the allocated time. Do I need to create a separate spreadsheet to capture ...

Hi! I’m trying to create a task generator, where I already have a list of task with the time it would take to get the task done and I want to input the amount of time I have and for the generator to spit out the tasks I can accomplish in the inputted...

Hello - I have a list of tasks in my spreadsheet and I want Appsheet to generate UNIQUE() as key column. Currently the ID column is blank. Under data, I have set ID column formula = UNIQUE(). But when I save, the error message tells me that I cannot ...