Sign in to join the conversation:
Hello,I am looking to remove a single cell from a grid and have the cells underneath move up but I am only given the option to remove rows which disrupts formulas I have in place. Is this feature of removing single cells available?
Hello Veronica,
There currently isn't a way to remove a single cell from a grid and have the other cells fill upward in its absence.
One thing that you might try is to drag-fill up your formula from the cells below, then deleting the information in the bottommost cell (as the cell above it should contain the formula after the drag-fill)
More on drag-fill here: https://help.smartsheet.com/articles/2476171-create-and-edit-formulas-in-smartsheet#dragfill
I'm trying to picture why deleting the row would not work, or probably better how the data is structured that this would be useful.
A cell is defined by the column it is in -- the type and that name mean something, and by the row -- there may be one or a few cells that define the row, a name or project number or a task brief description, but everything on the row is linked by that commonality.
By wanting to shift things in this way, the column where the cell in question is located must, by inference NOT be tied to the other things on any particular row, as the link between them will be broken when shifted.
Unless...
Unless you are trying to do something like a multiple row record. But then, only parts of the cells would need to be shifted, which would open up a new can of worms.
Just curious.
Craig
Hello, I am trying to create a chart widget in my dashboard, but I keep getting "Selected data cannot be charted. Please select a new range." error. The report I am using is already summarized in numeric value. What is funny is I have report that I created a chart widget in another dashboard, and when I use that same…
I have a picture below for an example of this. I want to create a formula to get counts of items in "Column2", but if "Column4" states "change" I want the "Column2" count to not work and instead count what is it "Column3" in that given row. Column4 can also have several different things in it besides "good" that I want it…
I've done this a million times - create a report, separated by campus with a total $$. Then add it to a dashboard and make a graph. NOTHING is working right now when I try to do this. I get an error that the data cannot be charted. What the what? Help anyone? Is this a issue since they apparently changed something in the…
