-
Scheduled Dates
I am a Project Manager working on a project plan for a technology company. I estimate dates based on the initial project kick-off date. I allow a certain amount of days for each process step. Example: - Kick-Off Date = 01/01/2017 - Estimated Development Start Date =[Kick-Off Date] + 7 = 01/08/2017 - Estimated Development…
-
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…
-
Want to track when actual completion date is greater than planned due date
I have set up a column to track the actual task completion date. I'm trying to set up a flag/conditional format where I can quickly see when tasks have been completed later than planned. I can't seem to set up a conditional format formula in the "Completion Date" column. How would you do this? Thanks
-
Percent Complete by Cell Color
Is there a formula to determine percent complete of a task based on the cell color? Cells are filled with dates of various steps in a project and once those are completed, the cell is highlighted. I'd like to have the percent complete column update automatically when the cell color is changed. Help, please!
-
Autofill Capabilities based off of Dropdown selections?
When selecting from a dropdown menu, can you build corresponding autofill capabilities into the next cell? I have a dropdown list of classifications that correspond to a weighting system. I'd like to be able to select a specific classification and have the following weight cell autopopulate. Is that possible through a…
-
format row with color on date
i have two columns, one is today date collumn and other is review date coloum , if my review date was 20-12-2016 and it today date is 21-12-2016, and it expired i want full row colour changed format and receive reminder setup. thanks you
-
Custom formatting - individual cells
Excel has the functionality to define custom formats by cell - for example, you can say that for each cell in a range, if the cell value is negative, then the font colour will be red, otherwise it will be black. Does smartsheet have this functionality? So far I can only see fuctionality to format an entire row based on a…
-
:% Completion Drop Down freeze
We are unable to use the drop-down option to update the % completion of our projects but it allows us to manually update it. It has being like this for about a week. How do I fix it?
-
Admin Control/Push Font Across Workspace/s
I would like to control and update the font for all sheets in every workspace. For example, I would like to change all data in workspaces/sheets to be Verdana 10. Right now we have different fonts across sheets. Then allow Contional Formatting be the only way for fonts to be altered. As admin can we have control over this…
-
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…
