Hello Community, I have a form which people fill out and the numerical data from which is analyzed and then put up on charts in a dashboard. However, part of the form is a text box where they can type…
I am trying to create an Index / Match cross-sheet formula if two cross-sheet criteria are met. Sheet One displays the Sales Reps for New and Modified Items: I want to display the Item Rep for NEW ite…
Hi, am working from a running sheet that currently has formulas but I'm trying to put the formulas into separate sheets so I can run metrics in a slightly different way and try to make the running she…
*What would be the best way to create a permanent link between cells. What I want is that if the user knows one of the bits of information, i.e. "WXP" that the other 3 cells get filled in automaticall…
Hello all! I am trying to have a cell auto populate information based upon values in another sheet. For example, in Sheet 1, I have the columns "Customer" and "Notes". In Sheet 2, I have the same colu…
I have two sheet that i want to reference and update each other. They both follow similar formatting, with one being more of a log/reference for the other. I would like one list to dynamically update …
Having difficulty trying to match 2 distinct values from one sheet to another. We have one dataset that tracks submissions on a daily basis from multiple locations. I been trying to find a way to matc…
I've scoured the interweb trying to figure out how to link from my Smartsheet into a share folder using an html link, and have tried several different methods, but keep getting this error message when…
Hello, I'm hoping there's an easy way to do this. I have three sheets, they all are filled in using forms. All three sheets are used for tracking things to be billed to the same list of clients. This …