Mar 16 2022 12:24 PM
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?
Mar 16 2022 02:17 PM
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.
Mar 17 2022 09:11 AM
Mar 17 2022 09:26 AM
Mar 17 2022 09:42 AM