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 s…
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 t…
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 con…
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 dynamical…
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 a…
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…
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…
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…
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 …
