-
Totals by Month using a date column
Is there a formula to count the # of entries for each month, using a system created date column? It seems like this doesn't exist unless you create a new column that says either 12 or December by looking at the date column.. thanks!
-
Setting RYGG Based on 2 Columns
I'm trying to set up RYGG based on a Finish Date column and a Status column. Here is what I have so far: =IF(Finish6 < TODAY(), "Red", IF(Finish6 = TODAY(), "Yellow", IF(Finish6 > TODAY(), "Gray"))) What I would like to accomplish past this: Yellow if 5 days prior to Finish Geen if 6 or more days prior to finish Gray if…
-
Nested ISBLANK Formula issue
Hi all, I've having some issues with the formula below and was wondering if anyone more knowledgable than I could take a look for me. I don't get an error message I just get a blank cell which is actually worse than an error message. =IF(ISBLANK([WPA2]47), [WPA1]47 + [>30PEE]47, IF(ISBLANK([WPA1]47), RCM47 + [>30PCM]47,…
-
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…
-
Using Percent Value to Set Dropdown
I am trying to use a formula to set a dropdown value based on the percentage value. Here is the formula I am using: =IF([Percent Complete]7 = 0, “Not Started”, IF([Percent Complete]7 < 0.26, “Just Started”, IF([Percent Complete]7 < 0.74, “Working”))) I am setting the formula in the dropdown cell and continue to receive…
-
Is there a formula to check one checkbox for a row that will check other checkboxes throughout the s
I am creating a sheet that contains the same item on multiple rows and need a way to link the checkboxes, so if one is checked all are checked. Please help!
-
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