-
Expand The Manage References Pop-Up Menu
When managing references in a sheet, the menu that pops up to begin editing/duplicating/deleting cross-sheet references is incredibly hard to work with. The box that pops up does not allow the user to expand the bounds of the menu - vertically, horizontally, or diagonally. Ideally, building the menu out with functionality…
-
Merged: Referencing a predecessor row
This discussion has been merged.
-
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…
-
Merged: Cell Linking And Referencing Sheet Summary Fields From Other Sheet
This discussion has been merged.
-
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…