-
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?
-
Adding Parent Rows in reports
I am still learning my way around in SmartSheets and need some more help! I have created a report to show all "Past due" actions by owner. The report only lists children as we calculate Past Due status at this level - not at Parent level. Is there any way to include parent rows in this report, even if they don't have a…
-
Images from Link to Other Sheet
Currently, when you double-click on an image that is linked from an inserted image on another sheet, SS opens the "Link" dialog. Wouldn't it be better if the larger image preview opened, like it would on the source sheet?
-
Mechanize Alerts?
I'm linking cells between two sheets A and B. When my project manager changes a row's start or end date in their sheet A that links to my sheet B, can I have an alert triggered by this change to notify me via email? Is there a better way to achieve this type of mechanization? Another way said, once my PM is done with a…