-
IF/AND Functions
I am trying to create a sheet that will auto update a number in a cell using multiple IF AND statements. Is it possible to have multiple IF(AND statements in one cell or what is the format? When I have one statement it works properly, but I cannot figure out how to have it work with two or more. I am not worried about the…
-
Multiple Projects - all with interlocking critical paths
Hello community I don't know if anyone else has this issue. I have multiple projects, resources etc, that all overlap. I have a VP that wants to see the critical path over ALL of the projects. Is there a way to do this? I know we have critical path capabilities within one sheet, but i dont see it in a report when i put…
-
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…
-
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
-
Automatically update formula every month
Hi, I have a sheet listing expenses for every month this year, and expenses for every month last year (Jan 2015, Jan 2016, Feb 2015, Feb 2016 etc). There is also a column for Total YTD 2015, Total YTD 2016 (if today is December, it would add Jan-Nov 2015 in one column and Jan-Nov 2016 in a column next to it; for…
-
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…
-
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…
-
Formula(s) to select & show project status
For each project sheet, I show the total number of tasks over due (red), due within 7 days (yellow) and not yet due (green). Now I want to create an executive report that shows a red, yellow, or green light for each sheet based on the category that has the highest number of tasks. Ultimately, the executives will receive a…
-
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…
