-
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…
-
Expanding a line and losing any lines beneath it.
On my Entresto PPEP 2016 Sheet-- When I expand line 46, everything beneath it is lost. How do I fix this?? Thanks!
-
Setting Up sheets to run multiple businesses
Hi I have 3 businesses that demand different work flows and I am having trouble getting my head around the best practice for how I should set up these sheets. Should I use one sheet to manage contact information for the 3 businesses and what is the best practice to link contacts to Quotes or jobs on other sheets ? Comon…
-
Question about creating a pricing sheet with multiple linked sheets
Hello, New to SmartSheet and have only been through the basic training video. I understand this product is super powerful and can do just about anything related to spreadsheets. I just wanted to reach out to the community to see if what I was looking to accomplish is something the group feels is obtainable before I keep…