Forum Discussion
Data entry
Hi,
I have a datasheet with measuring data named “Measures”
Each measure, among other, contains a “Parameters” field as you can see in the following screenshot.
The “Parameters” field is a string that comes from another sheet named “Params”:
What I need, is a form that will allow the user to enter data in the "Params" sheet for the selected measure on the Measures sheet and create a string from these data to fill in the Parameters field
Could you please give me some guidelines on how I can do this?
4 Replies
In K2:
=TEXTJOIN(", ";TRUE;IF(Params!$A$2:$A$1000=C2;Params!$B$2:$B$1000&" "&Params!$C$2:$C$1000&" "&Params!$D$2:$D$1000;""))
If the Params sheet has more than 1000 rows of data, adjust the ranges in the formula accordingly.
Then fill down.
- Hi,
Thank you for the tip however this is not what I am looking for.
I need an efficient way to enter data into the 'Params" datasheet while viewing the "Measures" datasheet, there is a connection between the two tables using the "Measure" field (the yellow highlighted)- Maybe creating a data type within Power Query would do what you want?
