Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Discussion List
Query String Syntax
I am having an issue with a query string syntax. See below. Trying to populate two fields when I send this out. I actually wish I could populate the form from data in the sheet but i dont think I can. Please take a look I have tried multiple different things Trying to populate an Order Field and a Name field…
Notifications - Direct Link to Changes in Specific Columns
Hi SS Community - We're looking to make discussions in Smartsheet easier for our users. Currently we have the notification set to address changes and additions to the comments column. The custom email is nice, but it's not exactly user friendly. Is there a way to hyperlink to an area of a smartsheet where a change was…
Weekly Input for multiple data points at multiple sites
We have been tasked to gather weekly meter data: multiple meters (3-10) for each utility (water, electricity, natural gas) at each of the 60 plants. What is the best way to gather multiple data points from mulitple plants all at once? We are unsure how to format this correctly. The plants will have to entrer Meter Name,…
Webform - Requesting an email
Most of my Webforms have a section on the bottom for the technician receiveing the form to fill it out and complete the form - I would like to put the request for a copy above the section that we fill out. Can that be made movable??
Report Builder: Adding Columns
Hello, I am building a Project Repository in Smartsheet. I am creating instructions for how to build a specific project report from the repository and looking at the report builder. Is there a function to be able to "select all" of the "columns" to be included in the report? In addition, is there a way to set them up in an…
Testing of Portfolio Management Features
Dear , As I am currently testing the portfolio management features of Smartsheet , would you please provide me with the following pre-formatted templates mentioned in your pdf : Project Portfolio Roll-up ( i did not find them via a Google search) : 1) Portfolio Master Calendar 2) Portfolio Risk Tracker 3) Portfolio Score…
Back Tracking Dates
I am trying to create a formula that can generate a date 2 weeks prior to a set date. For example: 9/1/17 - 14 days = 8/18/17 I assumed the formula would be as simple as "=[cell w/ given date] - 14" but it will not work and the column is a Date Type. Any suggestions?
using dates in countif formula
Hi all, I have an issue, I need to use a collumn with autonumber system format, in this case i have used date. the problem ocurres when i need to count all rows created in a specific date, it seems that the systems does not count the dates with hours after 5:00 pm or assignes the next day date if the hours surpases 5:00 pm…
Search using wildcard* not locating content in a sheet
Hello, Today a user asked how to make the searches in a sheet less restrictive. I offered the wildcard as a solution and as we were walking through the search it found 0 results. Within the sheet I have a column with a customer part numbers including revision example: 111-111111_RevA. I perform a search for the part number…
"Red" traffic light disappeared
Hi there, I'm currently using a "Red/Yellow/Green" traffic light status in one of my sheets, with the colour that is displayed being based on certain criteria. I've just noticed that the "Red" symbol does not show when it should (it was working fine before; "yellow" & "green" are still working ok.) I have not changed the…
