-
Filtering Calendar View
Is there a way to filter the calendar view to show more information (from other columns) rather than just the primary column information?
-
Update Webform URL's included in Folder when Save As New used
We are currently running multiple Projects and have setup a Master Folder with our Process Task lists in using Card View. Within Card View we have links to some Webforms used to capture Data for certain key tasks. The Webform sheets are located in the same folder. When we do Save As New using the Master Folder to Create a…
-
Setting RYGG Based on 2 Columns
I'm trying to set up RYGG based on a Finish Date column and a Status column. Here is what I have so far: =IF(Finish6 < TODAY(), "Red", IF(Finish6 = TODAY(), "Yellow", IF(Finish6 > TODAY(), "Gray"))) What I would like to accomplish past this: Yellow if 5 days prior to Finish Geen if 6 or more days prior to finish Gray if…
-
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…
-
Nested ISBLANK Formula issue
Hi all, I've having some issues with the formula below and was wondering if anyone more knowledgable than I could take a look for me. I don't get an error message I just get a blank cell which is actually worse than an error message. =IF(ISBLANK([WPA2]47), [WPA1]47 + [>30PEE]47, IF(ISBLANK([WPA1]47), RCM47 + [>30PCM]47,…
-
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…
-
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…
-
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
-
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…
-
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…
