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
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!
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…
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
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…
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?
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…
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…
Good afternoon! Hoping someone has experienced this issue before. We have established a number of conditional formatting rules for 7 drop down selections in one column labeled Site "A". If we add a new column for Site "B" and Site "C", can those conditional formatting rules be copied from the Site "A" column without having…
Hi Is there a way to format a row - based on when a partcular Cell was modified rather then when anything in the row was modified? In this example I would like to format the row based on how may days the Client has been at a particular status Thanks Lee