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. Archived 2015 Posts
Archives for November 2015
Discussion List
What is the best way to associate prospect contact information and sales tasks to a smartsheet sale
We currently use smartsheet for our sales pipeline. I love it. As our prospects move through our sales cycle, we simply move them down the list. I use the formulas to track all of our conversion rates and apply to project types and marketuing sources. I find this reporting and linking feature invaluable. We use the…
Conditional OR command
Is there a Conditional OR command anywhere. I see an "AND" but no "OR". So strange that I cant find OR since its part of any regular expressions and saves time.
Dropdown and Pick Lists
Hello, Is it possible to populate a dropdown list with the column of a seperate sheet. Scenario. We have a Sheet containing all our Assets and one for all our Work Orders. When creating a work order (new row) in the work order sheet, or via a webform, we would like to pick the relevant asset the work is linked to. If we…
update requests - how can find a summary of all pending update request from multiple sheets
is there any way to get a summary of pending update requesets from each user
Calculating output/production of resources
Hi there, I just found out that Smartsheets doesn't have a built-in way to configure the output/production for each person (resource). Has anyone figured out a hack for this? Ultimately, we run a painting company with 40 painters in the field. It is not unusual for each painter to be on more than 1 project during a given…
Excel formula =SQRT()
I am looking for a similar foruma to =SQRT() in Excel. Does Smartheet have this feature/function in its formula list?
Need to make some columns as required in update request form
I need to make some columns as required when sending an update request. Is there any work-around for this? If not, then can you add my vote as new feature request?
Formula
I'm trying to build a formula. Date range based off Finish date. Currently I have a date in the Finish date cell and it will populate a text based off the finish date but I really want to do a date range now based off the finish date. Example below the date range would be 02.01.16 thru 09.30.16. Can someone help me?…
Issues with Smartsheet and firewalls
I'm trying to assist a community of Smartsheet users working within a very controlled network. In order for their access to work correctly, I need to determine what Internet resources Smartsheet uses. Here is what I've seen so far: http - smartsheet.com https - app.smartsheet.com https - s.smartsheet.com https -…
One Note 2013
Dear Smart sheet representative Please advise the date when smart sheet will be integrated with one note 2013 (in a similar or "smarter" manner than the smart sheet/evernote integration) I need the functionailty for one note items, lists & notes to be added to smart sheet documents line by line. Best Regards Mahomed