-
Extract a number from the Left of a cell - HELP!
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 left of the survey response. eg. 5 - Very Satisfied 4 - Somewhat satisfied 3 - Neutral…
-
Auto populate Percentage Complete
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 external resource is in place. For example, after 1 month, it would say 30% complete. Many thanks, Siobhan
-
Resource Allocations based on Capacity
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 example, one electrician maybe able to handle 3 projects at a time vs another who can only…
-
Feature Request: timestamp() function
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-statement would be really great. =IF(FieldName1 = "blah", timestamp())
-
View your Card View by Assigned To
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 to view my Card View by all the people in lanes to whom I have assigned tasks but to do…
-
Smartsheet + Jira workflow - attachments and multi-select
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 to the new jira story created from the line item in the smartsheet? it doesn't appear as an…
-
Enhancement Request: Allow downloading Activity Log
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 yet have access to the data via the API (I posted on stackoverflow requesting this) I…
-
Activity Log Export
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 companies as well. Thank you!
-
Publishing only filtered list to google calendar
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. I've attached a detailed description of the issue I'm facing with screenshots. Does anyone know…
-
Automate RYG Balls based on % complete and start and end dates
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 two dates, to turn yellow. If my % complete is less than or equal to 90% by the end date…
