I have a sheet to track travel, which includes a Start Location column and End Location column, and a third "Start - End" column which contains a formula that combines the first two columns. I've done this so that I can reference another sheet, which has the estimated cost from Location A to B, using DataMesh. However, this doesn't seem to work and I wonder if that is because I'm asking DataMesh to use the "Start - End" column as the lookup value. Is it possible DataMesh doesn't recognize the formula output, but instead reads the formula? This would render it useless in this case, so I figured I'd check before I continue troubleshooting.
Thank you!
