-
Smartsheet Merge & Google Sheets
Does Smartsheet Merge App work with Google Sheets? I have been using the Smartsheet Merge App with the Google Docs, however, when trying to use it with a Google Sheet, it doesn't appear on the list. It seems a shame not to be able to when Google Docs does..
-
New data from Web Forms lands outside analysis range
We have a number of Smartsheets that gather data using web forms. Once the data has been gathered we analyse the responses received via the smartforms using formulea at the botton of the sheet (COUNTIF) This works really well and once we have this data in we can use the charts available in Smartsheet labs to present the…
-
adding service records to a row
I have a plant & vehicle register that I want to add service records to. So each row is a vehicle and I want to keep each service record as a history of the vehicle then I need to export the record for my clients is there a way to do this without adding extra columns?
-
Milestones Report on a Sight
I've got a Report that I'm pulling into a Sight. While in the report, I properly see the diamond symbol for my milestones, yet, once I pull the Report into the Sight, it's showing me the bar, not the diamond. See the screenshots - the one showing the diamonds is when I generate the report. The one with the blue bar is the…
-
Export to letter formatted document
Has anyone tried building a sheet that would have a presentation level, letter format when exported? I'm looking to build proposals within Smartsheet, then I could cell link that final/approved fee into my project tracking sheets for cost comparison etc. In Excel you would typically do this via cell merging etc, but that's…
-
Auto Formatting with New Row Entry (via Webform)
Scenerio: Row 1 and Row 2 have a Blue Background for all 6 Columns. I created a webform to add above these 2 rows for all 6 columns. When I submit the webform, the added row does not receive the lower background on it. This use to work, and now for some reason it is not. Let me know if anyone has any fix, thanks!
-
Revenue per month Formula extending beyond 1 year
I have a sheet that I have created to forecast revenue per month based on forecasted schedules and dollars/project. Currently this just goes for 1 year, but with projects now starting late Q4 2017 and going into Q1 of 2018, I am needing to revise this formula to add a year definition. Would love if someone could take a…
-
Shared reports are blank
Hello, After performing a search I ran across many others users running into shared reports showing up as blank pages. I tried the solution I ran across and assured that the user also had access to the sheet the report was made from. And still I am seeing a blank report. Was this ever corrected in early/mid 2016? I am…
-
Contact list and webforms
Hi, I have a column on my sheet which is the contact list. However, in the webform it does not show as a contact list. So I had to go and make it a dropdown with the exact same options as the contact list. Now, these sheet line items are not pulling through on my various reports. Because in the report builder I must now…
-
Help wanted
We re looking for a subcontractor to assist in design and implementation of construction scheduling, task management, and resource allocation for a small construction company. Presently, working with Microsoft Project and need to revamp our solution with Smartsheet to be more detailed, efficient, and useable.
