SMARTSHEET MERGE, HIDE SPECIFIC COLUMNS
I built a Fund Allocation Request form that makes people produce PDF for printing at the end of the process. To be able to produce the PDF, I use Smartsheet Merge. But I ran into an issue of confidentiality. Since the form is a finance thing, we don't want the users to see how much funds are requested for each items. Yet the sheet should be shared to users so they can use it during Smartsheet Merge. I solved the problem in the sheet since it can hide columns. But then in smartsheet merge part where I need to choose columns to merge, the columns I hide are still appearing, which made the hiding of columns in smartsheet useless.
Any ideas how I can turn this around? Screenshots are provided below. Grid and Smartsheet and Smartsheet Merge. The amount is the one I need to hide.