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 2016 Posts
Archives for December 2016
Discussion List
Feature Request: Update Request confirmation has same title as the Update Request
When I send an UR to someone for a row, the title of the UR shows the name of that row plus whatever I add. However, when they complete the UR, the confirmation only shows the title of the sheet. Also, if I send the same people UR across many days, I have no way of knowing what they completed for these days unless I open…
Month Count/Summary as Integer
I have looked for examples but can not find - apologies for basic formula question. From a date field i would like a formula that will take the month and total/count by month: Eg: Month 1 - Total 15 Month 2 - Total 9 to Month 12 - Total 0 Can anyone help? many thanks Chris
Autonumber refresh for new year
I use a formatted autonumber column to record a new Reference Number for each new entry in a Smartsheet. The format I use is CR{YY}.000 where 000 started from 001 for the year 2016. I want to continue this format into 2017, but I want the 000 to restart from 001. Any thoughts ? My list of rows should end up like : CR16.001…
Notification when comments change
I am trying to get automaically notified when someone adds a comment in the System comments column (circled in green). Thoughts?
SmartSheet Jira Integration
Hi all, I'm new to smartsheet and have also purchased their Jira integration. I'm curious as to how many others here are using this integtation? There's a lot of quirks with the integrations so wanted to see what others thought of it and how they're using it. Cheers, Imran
Printing thumbnails of attachments.
I have a sheet with calilbrated tools and each tool has a specific ID and calibration date. Along with each tool I have attached a pic of each tool. Is there a way to include a thumbnail of the pic next to each tool row when generating a report or viewing it on screen? It would be nice to have an option to display a…
Create a resource view
I have a number of sheets with a large number of people on a team all doing part of the work. The Report feature is good at showing the tasks on a gant chart across the business but it presents it as one line per task which means that there are possibly 15 lines for one person. Thats a bit difficult to manage. The calendar…
Formula(s) to select & show project status
For each project sheet, I show the total number of tasks over due (red), due within 7 days (yellow) and not yet due (green). Now I want to create an executive report that shows a red, yellow, or green light for each sheet based on the category that has the highest number of tasks. Ultimately, the executives will receive a…
Internal Enterprise Templates
Has anyone developed or use an in-house template area for the Smartsheet solutions created on their account? An in-house "solution center." Our enterprise account has 550+ users. We are looking for a way to share and make available, Smartsheet solutions that have been developed on our account and may be useful in other…
Sharing "My Smartsheet Contacts"
How do I share my smartsheet contacts with all users? I'd like to be able to have a list of all contacts to be able to use as a "filter/search" item whether I am in Helpdesk/Pipeline/CRM etc. Is this an option?
