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
Archives for January 2017
Discussion List
Hiding data in my project plan for specific users
Hi, I read related smartsheet discussions on this. Is there a solution for this other than hiding the columns which contains the info you do not want to share with other users? I have budget figures on my project plan, and only 3/8 users are allowed to see it. I know you can create a seperate sheet and insert links. But…
Conditional formatting across multiple sheets
Is it possible to set conditional formatting to move an item from one sheet to another once it is completed?
Enhance Reports to allow selection criteria that compares two fields within a row
Hi There, I would love to see the reports tool enhanced to allow me to show records where the Projected Closure date on a row is less than end date. We link a field from a planning/revenue projection sheet that shows when the project will be billed with the actual end date of the project from within its project plan. If…
Is there a way to re-designate the primary column after a Smartsheet has been developed and populate
I would like to switch the information that is displayed in the calendar view to data that is present in another column within my sheet.
Can Smartsheet show a Gantt style bar that shows monthly RAG status trend?
I am new to Smartsheet and have a POC developed in Excel that allows us to have a gantt style timeline that is coloured by month according to the monthly RAG status. This RAG status is conditionally formatted based on whether we indicate 1, 2 or 0 in the cell but is not shown. We can also add activity descriptions in the…
Merging MS Project information into SmartSheet Project
I manage a number of projects using SmartSheet for my company. We employ multiple subcontractors and vendors on these projects who use MS Project to manage their activity, but we report on the aggregate project inside our company with SmartSheet. I receive regular (weekly), updated MSP files from the subcontractors, and…
Commission sheet
I'm looking for a Sales Commission sheet that tracks sales, commissions earned, etc. We have a junior salesman and a senior salesman who produces and earns overrides on the junior. Much appreciated if you could share one or perhaps a screenshot to get me started.... Thanks - Scott
Using Percent Value to Set Dropdown
I am trying to use a formula to set a dropdown value based on the percentage value. Here is the formula I am using: =IF([Percent Complete]7 = 0, “Not Started”, IF([Percent Complete]7 < 0.26, “Just Started”, IF([Percent Complete]7 < 0.74, “Working”))) I am setting the formula in the dropdown cell and continue to receive…
Establishing connection between Informatica Power Center and Smartsheet
Establishing connection between Informatica Power Center and Smartsheet
How do I create a report that groups different sheet data by week, then ordered by date?
We have separate sheets for our different editorial teams -- like this: - TASK 2 (from team 2's sheet) - TASK 3 (from team 2's sheet) - TASK 4 (from team 2's sheet) thanks superheroes! m