-
How many cascading multiple sheet dependency can smartsheet can do?
HI, Its me again doing cascading dependency on different sheets. I tried 2 cascading project sheet dependency and it works. I try doing 3 tomorrow but a question lingers: How many cascading multiple sheet dependency can smartsheet can do without any issue? Thanks D Micu
-
Cross sheet links automatically update with new rows
I'm working on developing master sheets for my group that other researchers will link to. They will use this information to inform capacity and resources. How do I ensure that if I've added a row to the master sheets that it automatically updates their sheets?
-
f(x) & Edit Reference do not appear
The help documentation states the following about cell references: “You can edit the name, referenced cell range, and source sheet of the reference.” If using a long formula and selecting the cell containing the formula, the left-most portion of the formula is not visible on the display (i.e., f(x) = AND Edit Reference do…
-
Reference Row Number?
I'm building a task management sheet that prioritizes tasks by their order on the sheet. A formula calculates lead time of a task based on its current position in the list. Is there a way to dynamically reference the row number of a task? The easiest way would be a function that references the row number (since those…
-
Parts of a whole inventory suggestions
Hello! we use Smartsheet mostly for inventory management and I was wondering if anyone had some suggestions on how to write a formula to automatically subtract the parts that go into each item while also subtracting the completed part. I currently link in the part inventory from one sheet and update it there so that it…
-
vlookup not updating
Has anyone had a problem with vlookup not updating? I had a situation this morning where vlookup was not refreshing the correct value when the search value changed. The way I found to fix it was to re-type the entire formula.
-
Automatically marking something as complete when requirements are filled
Hello, I was wondering if someone would be able to help me with a problem that I have been struggling with. I would like to make it so that when a checkbox is checked, in another column, called status, that it would switch and say complete. The status column is a Dropbox, containing Completed, In-progress and Not started.…
-
A-Z Rows
hi ive set up a couple of new sheets and looked to sort the rows A-Z but wont allow me? any ideas to fix this problem ta
-
Sights needs some improvements
Sights has been out for about six months now, but there are still no graphing widgets. When is SmartSheet planning on coming out with this functionality? Graphs are some of the main things people will look at when viewing a dashboard. Currently all we can do is list a whole bunch of raw numbers with little to no visuals. I…
-
Linking colums from one sheet to another issue
Good morning, I am trying to set up a master document with linked cells across three different sheets. First being an order form, second being a shipping form and third being an install form. All the information will link back to my system ID of which system is being installed. My question is when I highlight my cells I am…
