-
Need help with sheet reference formula to grab assigned user for a specific day.
I am working on some cross sheet data and sharing and would like to list in a cell of a sheet the user [Technician] assigned to a space [Bldg-Room] on Thursday from another sheet. There is a column for each day of the week on the sheet being referenced. [Thursday] I can use this formula within the current sheet but I seem…
-
Attempting to create a formula to find items assigned to a contact from a drop down.
I hope my title makes sense. I work in a veterinary Setting, I am working to make some metrics for a sheet dashboard and I am trying to get a cell formula to show me how many of a category is assigned to a person. I have been able to figure out the totals per category in my sheet but now I want to be able to see it at the…
-
Strange INVALID VALUE error
Hi everyone, I've encountered a problem in Smartsheet that I tried solving for a long time without success. I was creating metrics for a sheet, and I made a bunch of summary fields that contained my formulas. They all worked as intended when I created them. About a month passed without anyone touching them, I went back to…
-
Linking a field in a form to a source sheet as picklist
I already put in a ticket and got the answer this is currently not possible, but was encouraged to put in a post here to hopefully being integrated one day. In my situation we have a huge list of project names (and constantly growing) that we'd like to be able to pick from in a from related to a SmartSheet. We find that…
-
Question about Templates and Formula References
Hi, I am creating a template of a "Cost Estimator" which will be created into a new sheet each time I have a new project. The Cost Estimator sheet will link to a master Project List using the Project ID and the Project Name. What I am attempting to do is create a Cost Estimator "Totals" sheet which will have a row linked…
-
Could a referenced cell formula be messing up my SumIf Formula?
I have two sheets. Sheet A with a list of Projects, Project ID, and Amount of Funds awarded. Sheet B contains order information. The information is taken through a FormStack Form, but on this form, the project owner selects their project name that is basically a list of their project combined with the project ID. Once that…
-
Cell Linking And Referencing Sheet Summary Fields From Other Sheet
Sheet1 has Sheet Summary fields. Sheet1 can access it's own Sheet Summary fields. A Report can access the Sheet Summary fields from Sheet1 (or any other sheet). A Dashboard Metric Widget can access the Sheet Summary fields from Sheet1 (or any other sheet). - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -…
-
Outgoing Cell References
Is there any way to find where all outgoing cell references go? What sheets, DataMesh, etc. are referencing a particular sheet, even if I don't have access to the requesting asset, what assets are using this sheet? The activity log does not appear to show when formulas in other sheets reference the data. I can see when…
-
Help With Index-Collect and Cross Sheet Referencing
Hi all, I am attempting to return a Contractor's name from a source sheet using multiple criteria (if they are subcontracting and what their scope of work is). The issue I am running into is the unique ID I use to connect the sheets (The PCM Number) has duplicate values when there are subcontractors (multiple contractors…
-
Reference or copy a column in one sheet to another sheet automatically
Hi, I am trying to figure out a way to automatically get specific columns in one sheet, into another sheet I was originally looking at using a workflow to copy the rows over, but I only wanted to copy a subset of the columns which doesn't look to be possible. Then I started looking at cross-sheet references, but the posts…