-
Update Request with "add/subtract" formula to an existing number in a row?
A bit new to SS, so this may have an obvious answer, but I'm trying to set up a sheet to track inventory of, say, a dozen products. The initial setup is obviously simple, but then I want to choose the product rows that contain inventory quantities, and set up an automated Update Request to my delivery driver via email each…
-
Change notification for linked cells
Hello, i have a problem you maybe can help me to solve. Roadmap- The roadmap is linked to a project sheet (starting time and duration) Task = Same name and specifications If I change the values now in the project sheet there is in the roadmap the value also automatically changed (cause of the link for sure) Is it possible…
-
for one project today all task lines over 1 line height do not show the same height in the task numb
here is what I see, it only applies to one of my projects and I logged out and logged back in to smartsheet and the problem persists. Causes problems when I want to update values in columns to the right with the input box, for dates for example appears 5 lines above where I am expecting it to
-
Sheet Title in a cell
Is there a way to pull the sheet title into a cell within the sheet?
-
Linking within Sheet
I know you can use = to link cells within a sheet, but if I needed to link an entire row, is there a way to do that? Or even a couple cells at a time? I tried highlighting all of the cells I need to link & doing a bulk edit sort of thing, but that didn't work. Wanted to ask before I spent an hour linking a million cells…
-
Is there a way to select from a project schedule the next upcoming milestone?
Is there a way to select from a project schedule the next upcoming milestone. I have a flag column identifyng milestones and a column that calculates for just milestones the number of days between the task finish date and today's date and therfore the lowest value is the next upcoming milesone. I desire to pull the…
-
Once 'complete' can I move an entire row to another created sheet
Once a line item (row) is marked YES complete, can that entire row (with or without formatting) be moved to another sheet so that it is not shown on the in-progress/working sheet? Or... can I move an entire row within the sheet if a specific column is marked such as conditional formatting. Thanks
-
Repeating rows based on one cell value
I am try to go from a proposal to a detail sheet for our business. We make doors and you can have from 1 to about 100 or more of one type of door. On the proposal it is only shown as one line with a quantity cell. Now what I want to do it link that to a detail sheet, the sheet that will go to production, and list those…
-
Reporting tool for invoicing
I run a consulting company and would like to build a sheet where the staff can report on the time they have worked for certain clients. We invoice AM and/or PM blocks, not per hour. I have my clients in a drop down box. How can I make a summary sheet that links to the individual consultant reporting sheets in order to…
-
Feature Request - Dual Windows
OK, so when you're making alot of links to other sheets, it becomes tedious that you have to do the link one at a time - switching back and forth between the sheet and the pop-up of the sheet you're linking to. There are also other times when it's nice to have more than one sheet visible at a time So if it were possible to…
