-
Combine dates from multiple sheets into one calendar
I have 3 sheets, one for marketing, one for sales calls, one for training. How can I combine the dates/items from each sheet onto a master, to create a master calendar that I can then export to ical and put into my outlook?
-
Can a Report Configuration ... "Include Parent Rows"?
Smartsheet has been a wonderful tool for my team since 2015. A couple things (out of many) I like are the quick sorting options on a sheet and the easy report configuration. With one nusiance exception, and I keep running into this ... On a sheet I can apply a filter and click on a box that will cause the inclusion of the…
-
Seeing all my text in Calendar view.
In calendar view, how do I get my all my text to fit? It won't wrap. When I export from Calendar view in excel, it comes to me in grid format. Exporting the Calendar view in an PDF format doesn't help becuase I cannot manipulate the text so that I can see it all. HELP!
-
Auto-generating Google Campaign URLs with Smartsheet?
I would love to create and manage Google Campaign URLs with Smartsheet. Ideally, I would enter the URL and associated variables, and in the final column it would generate the complete campaign URL, just like the official Google URL builder (https://ga-dev-tools.appspot.com/campaign-url-builder/). Specifically, I suppose…
-
Parent Date Roll ups - Possible for two sets of dates?
I have a head scratcher here, thanks in advance for any help that anyone may have. My scenario is this, I have project plans that have two sets of dates, one is estimated dates and the other is the actual dates on the project tasks. In my project settings the estimated dates are linked to the dependencies. When I enter in…
-
Sheet scrolling with mouse issue
Hi, I am unable to sheet scroll using my mouse. Pulling the side tag works but not with mouse since today. Any reason for this? Rgds Ian
-
How do I get my "IF" formula to automatically add to new rows?
We use zapier to add rows to the top of our primary active sheet from Pipeline. Within the active sheet are formulas set up for adding dollar amounts and hours. When a new row is added, these formulas carry "up" to the new row added in. However, I have an "IF" statement that will translate zip codes into cities (below).…
-
Start Date Autofilled by End Date and Duration
I'm building a construction schedule for cabinetry across multiple projects my company has going. Is there a way to dictate a start date, date the vendor needs to start working, by the known building/finishing time and the end date, date they need to be on site. I.E. I'd like to put in the end date: 1/22/18 and a duration…
-
MS Flow Integration
I am currently trying to use MS Flow for workflow task automation for various projects. Does any documenation exist on how to access the data within the sheet? It appears that the dynamic data available only presents a limited set of items that are not detailed enough.
-
Enhancement Request: Ability to use Rich Text or HTML format options for Comments
I would like to request the ability to use different format options in the comments window. We are currently able to add plain text comments but it would be nice at times to use a different format like Rich Text or HTML.
