-
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…
-
Webforms: Auto hide based on answer of other field; Alerts based on answer of field
HI, I have a few questions. Scenario: A team fills out a webform every time that a they take a call. There are different fields available to them to fill in. Some of these fields(especially towards the bottom) do not apply if one of the first fields they fill out are filled out with a specific answer. each of these fields…
-
transfer rows form 1 sheet to another
Is it possible to add a micro that will automatically send rows from 1 sheet to another once a completion date in a colum has been reached?