-
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.
-
conditional formatting
Hello!! Hopefully someone can help.... I would like to run a conditional formatting where I enter a number in column 1 and that will produce specific text in column 2 I can only see option of changing the cell colour and not having the condition produce a line of text Thanks Celine :o )
-
Links not updating
Hi All, I would appreciate it if someone can help me out. I double checked that my links are linking to the correct areas between two sheets. But it is not updating the sheet it links to. Please advise and see screenshot. Thanks, Y
-
Auto-fill form/cells when a certain item is selected from a drop-down
I was wondering if it is possible to auto-fill cells based on an item that is selected from a drop-down. I am trying to create a form for our subcontractors to upload submittals and I wanted them to be able to select from a drop down list what they are submitting. I.E. Product Data for Paint, or Samples for flooring. Once…
-
Generic "Forms" embedded in a sheet?
HI, I am pretty new to Smartsheet so, please forgive me if the solution to this question is obvious to most. :) Our company is developing some project management sheets to help us in our transition to paperless. We have put together a template that we feel pretty satisfied with to get going and as we start each project, we…
-
Count the number of projects in a folder
Our team is looking for a way to count the number of projects of three distinct types. I have them located within three different folders. I do not want to have to use cell linking. A user should be able to create a new project without having to open a summary sheet and create a new cell link. If I could use a formula in a…