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 2017 Posts

Discussion List

  • Extract a number from the Left of a cell - HELP!
    In Archived 2017 Posts
    Good Day to ALL. I am new to the vommunity and need some help.... I have a survey form for my clients and when the results are populate, I would like to tally the results - by client. What I am looking to do is extract the number to the…
    741 13
    Closed 741 views 13 comments Most recent by Mike Wilday
  • Auto populate Percentage Complete
    In Archived 2017 Posts
    Hi,   I have a "task" in my sheet which lasts for 3 months.  Is there a way to autopopulate the percentage complete based purely on the time passed?   It is not a measure of outputs / delivery but just showing how long an ext…
    7342 7
    Closed 7.3K views 7 comments Most recent by Todd Smelser
  • Resource Allocations based on Capacity
    In Archived 2017 Posts
    I am trying to figure a way to do resource allocation based on the number of projects a particular sub can handle at one time.   We have 20-30 projects next year and trying to award bids based on capacity of the subcontractor.  For exampl…
    PDC Profile Photo PDC
    43 3
    Closed 43 views 3 comments Most recent by Andrée Starå
  • Feature Request: timestamp() function
    In Archived 2017 Posts
    It would be great if there was a way to timestamp the value of a cell. To enter the exact date that an event occurred. Several people have volunteered a modified date column, but something like the following functionality in an if-statemen…
    1093 23
    Closed 1.1K views 23 comments Most recent by Andrée Starå
  • View your Card View by Assigned To
    In Archived 2017 Posts
    I think I have found a novel way of using an Assigned to column that has a contact list column property as the lanes in Card View, BUT I wanted to check with the community if this approach wont cause problems.   What I do is when I want t…
    1460 4
    Closed 1.5K views 4 comments Most recent by Robin Sherwood
  • Smartsheet + Jira workflow - attachments and multi-select
    In Archived 2017 Posts
    We are using a smartsheet to populate a jira project.  basically, a user fills out the webform, it updates the sheet, and then we push that into jira.     The first issue I'm having is attachments. Is there a way to attach the attachment…
    242 10
    Closed 242 views 10 comments Most recent by steve.estoque72076
  • Enhancement Request: Allow downloading Activity Log
    In Archived 2017 Posts
    Allow some means to download the Activity Logs from one or more objects that support the logs. This could either be locally when viewing the source or buried in the Account Admin menu if determined to be a SysAdmin function. We do not ye…
    301 12
    Closed 301 views 12 comments Most recent by Andrée Starå
  • Activity Log Export
    In Archived 2017 Posts
    Is there a way to export the Activity Log once filtered? We would be able to use this for our metrics. It would be a huge time saver and really make SmartSheet that much better for us! I am sure this could be used in this manner for other …
    305 6
    Closed 305 views 6 comments Most recent by Stephen D van der Werf
  • Publishing only filtered list to google calendar
    In Archived 2017 Posts
    I'm having an issues with "Publish to Googgle Calendar". Every time I've publish some task in google from SamrtSheet, SmartSheet publishes everything in my Google calendar instead of publishing the specific tasks assigned to me. …
    362 9
    Closed 362 views 9 comments Most recent by Restructor
  • Automate RYG Balls based on % complete and start and end dates
    In Archived 2017 Posts
    I would like to have the RYG balls automatically adjust based on the percent complete and start and end date.  For instance, if my task is set to start on 10/2/17 and end 10/13/17, if my % complete is less than 50% by midway between the t…
    237 4
    Closed 237 views 4 comments Most recent by Andrée Starå