-
Setting flag when task falls within a date range
At my company we have certain dates when we do not make changes to our website (holidays usually). I'd like to be able to highlight or somehow flag a task if it falls within one of the freeze date ranges. Is there a way to do this?
-
Report Not Updating
I have several reports setup to filter a sheet by status and up until today everything worked fine. Now, when the status changes, the report doesn't get updated and I don't understand why. For example one of the reports filters for a status of "Design" and when I perform the necessary steps to move it out of the "Design"…
-
Copy Column Properties
Hi, I am creating a new sheet that needs to have 20+columns that are all a dropdown column type, with the same dropdown responses. Is there a copy function for setting up the columns? Thanks, Lisa
-
COUNTIF where cell contains checkmark EXAMPLE
Need a 'countif' example, where cell contains a checkmark?
-
Sumifs with Date Range
Hi there! I'm using Smartsheet to keep track of timelines and allocated ressources called FTEs across multiple projects. I'm trying to figure otut a way using the SUMIFS formula to sum up the usage of FTEs across all projects per month. Currently, I'm using =SUMIFS(FTE:FTE; Projekt:Projekt; "Project A"; Start:Start;…
-
Formulas For Metrics
Good afternoon, Looking for some help on setting up formulas to capture the following metrics per attached. Any help would be greatly appreciated. Thank you !
-
Modify scale on an axis of a graph
Good Day t´s possisble modify scale in an axis of a graph exist? for example, I have a graph, in the vertical axis the scale it´s 0.5 to 0.5, but i want that scale will be 1 to 1, it´s possible? regards
-
Formula Sumif Range w. Web Form
I have a sheet where I am using a Webform to gather data. Issue is the Sumif formula I have at the top of my sheet will not include the added line entries of the webform entries. =SUMIF(Task2:Task4, Task5, Hours2:Hours4) New Webform entry is line 5, Formula will not automatically capture that added line. Please help.…
-
Love "PRORATE"
The PRORATE function does not exist in Excel (to my knowledge, reinventing it was cumbersome). We use it to spread budget accross time. Indeed, with the right columns and rows, Yearly (can be quarterly, monthly or whatever) budgets adjust as the dates change. Then dedicated boxes consolidate to overview at a glimpse.…
-
Issue with Nested IF Formula
I am having trouble getting my nested if formula to work. I have the following formula: =IF([DCO Status]@row = "Implemented", "Blue", IF(AND([Days Open]@row > 46, [Days Open]@row < 100), "Yellow", IF([Days Open]@row >= 100, "Red", IF([Days Open]@row <= 45, "Green", "")))) It is working for all the cells except the blank…
