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 PostsGood 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…
-
Auto populate Percentage CompleteIn Archived 2017 PostsHi, 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…
-
Resource Allocations based on CapacityIn Archived 2017 PostsI 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…
-
Feature Request: timestamp() functionIn Archived 2017 PostsIt 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…
-
View your Card View by Assigned ToIn Archived 2017 PostsI 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…
-
Smartsheet + Jira workflow - attachments and multi-selectIn Archived 2017 PostsWe 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…
-
Enhancement Request: Allow downloading Activity LogIn Archived 2017 PostsAllow 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…
-
Activity Log ExportIn Archived 2017 PostsIs 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 …
-
Publishing only filtered list to google calendarIn Archived 2017 PostsI'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. …
-
Automate RYG Balls based on % complete and start and end datesIn Archived 2017 PostsI 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…
