Agreed! Not sure why that’s the case…

Could you create summary fields in the sheet, and include those in the report?

I completely agree. It’s not priced to the market for my client’s applications.

For security reasons, you should never use a linked field directing users to master data fields that could be guessed or inferred. That being said, if you use this feature you should be aware of it’s implications.

Haha! I know, right? What I would also like is one that is prepopulated and LOCKED for input but still shown on the form.