-
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…
-
RYG Balls Not Displaying Anymore
I built a report off of a seperate smartsheet that had RYGB Balls to help identify that status of the entry. The RGYB Balls are no longer displaying as a ball/bubble but instead as text of the color. I am not able to change the status of these entries for the rows that have the color text instead of the bubble. It will…