-
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…
-
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…
-
Webform - Enter a default formula instead of value for Symbol data type
I'm hoping someone can advise how to get around this issue. I have a new sheet I'm creating which acts as a checklist in a fixed process. i have several columns which cover off stages in the process, and there is a master flag as well which sets its status based on where there other stages are at. This Master Flag will…
-
How to track new Smartsheets
Is there an easy way to track new sheets created? I'm the account admin, but other users want to create sheets as well. My problem is tracking those new sheets to ensure they adhear minimum standards. Thoughts? Jim
-
Widgets do not make it into reports
I am pulling a report on a project that has a progress widget. It is a status bar. When i pull the report i get he list below. Why is that? I am assuming this is a bug? In fact, now that i think of it. I think the widgets used to be there but now they are gone after the update. Three Quarter Three Quarter Empty Half Three…
-
Including only the most recent comment.
Hi there, Within the "Print Setup" for .pdf reports, under "Options", "Include comments" checkbox....when selecting this checkbox it prints out the full set of comments which is fantastic but can make the report quite lengthy, especially over time. However is there a way, or is it possible in future upgrades to select an…
-
RGYB Ball Color not showing on report intermittently
I have a report that pulls a summary row from various smartsheets. I have a column in these sheets titled Progress Indicator. I have a nested IF statement to show the correct ball color. I just noticed that some of the sheets are pulling in the actual ball symbol and some are giving me the text name of the color. When I go…
-
Augmenting SmartSheet
Hi there SmartSheet Community, We are using an existing system for job management and for accounting, and have introduced SmartSheet for the management of project plans. In order to meet the requirement for consolidated reporting of project financials and capacity, we have carried out a deal of augmentation around…
-
Report showing dropdown word and not icon
Hi, i have a report pulling through from various sheets. All reports have a priority column - Low, medium and high. Since yesterday some of the rows on the report shows the words "High" and other shows the icon "!". Is there something wrong with the reporting feature. This was never a problem. I want the ! to show and not…
-
Reports - Dropdown Functionality not working
Hi, As many are experiencing report dropdown functionality is not working. This seems to be for RGYB balls, as well as other dropdown lists. I have tried turning the dropdown columns to normal text columns to solve this issue, but this does not seem to work either. It appears to be a deeprooted bug. An update ASAP would be…
