-
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…
-
Gantt Sheet - Linking Dates
How can I generate the sub dates on a Gantt sheet using the duration? I would like to be able to copy my project and the subdates automatically generate from the head date? This could be generated by the duration. For example If the Head start date is 1/3/2016 I would like the sub dates to auto generate from the duration…
-
Can If-Then formula populate Primary column?
I need to populate the information in the primary column from a dropdown menu but cannot because of the type of column. If I place a column next to it with the dropdown information, can I use an If-Then formula such as =IF(ISTEXT([Client name drop down list]1), "Text", "Not Text") where I change the "Text" to equal…
