1
0
-1
1 answer
- 10-1
Hi, I am not sure about the table structure portion. For the drop-down list, according to the Spreadsheet page there is a special FORMDATA function where you can "Use this function to 'pull' and populate a spreadsheet cell based on available data in other forms."
Add your comment...
Hello team
I am developing an application in which various processes are going to be used as activities of a project. That is, through a process of control, the application will be responsible for initiating processes according to a project structure, taking into account the termination of predecessor activities (processes).
Although I am already ahead on this issue, I have some problems with the initial structuring of the project. Basically, I need a table structure in which I relate the name of the activity (1), the type of process, the start date, the expected duration and the predecessor activity.
For this last point, it would be ideal if you could choose any of the previously entered activities from a drop-down list: something similar to the "data validation" function of Microsoft Excel or the VLOOKUP function. Is there any function in the spreadsheet component that can emulate these functions and additional material on the advanced use of these functions, such as MATCH (since I could not find how to use them correctly)?