 # Nic Larsen’s Profile

points
496     I have been tasked with creating multiple sheets that feed into reports. In going about that process the sheets are populated by Project, Customer Issues and Roadmap sheets. Currently, I am trying to count how many Customer Issues were opened up between specific dates (Q1, Q2, Q3, Q4). I currently This should be fairly simple, but I am spinning on this syntax.   Trying to sum my "Invoiced" column if the Year Column = "2019" and the Type Column = "Expense".  I have tried a few variations, but this is what I think should work?

=SUMIFS(Invoiced:Invoiced, Type:Type, Expense, Year:Year, 2019). Currently, I am using this formula

=IF([End Date]396 < TODAY(), "Red", IF([End Date]396 = TODAY(), "Yellow", IF([End Date]396 > TODAY(), "Green")))

for health status.

What I would like to do is tweak this, so that if a task is less than 75%, and due in 3 days, the ball is YELLOW. Everything else Hello everyone, sorry if my grammar is bad. I am Chilean and I recently use Smartsheet, I have learned a lot in a short time. Now I need to solve this formula.

Grey =  IF Stock Column is “ “ (empty)

Red = IF Stock Column is “0”

Yellow = IF Stock Column <= Critico Column

Green = IF Stock > Critico EDITED TO ADD:

I was able to figure out this morening w/ fresh eyes/brain and tested all scenarios which tested true:

=IF(OR([STATUS]@row="Barrier",AND([Due Date]@row<TODAY(),NOT([STATUS]@row="Completed"))), "Red",IF([STATUS]@row="completed", "Green",IF(AND([Due Date]@row<TODAY(+3),[STATUS]@row="Not I am trying to calculate a variance by subtracting two columns but only if one of them is not blank.  I'm having trouble getting the ISBLANK condition to work.

My current formula is  =[Budgeted Total]4 - [Amount Spent]4 but I only want to apply that formula if Amount Spent is not blank.

Any I am having trouble creating a formula with 2 conditions. I currently have formulas in a Spend summary sheet that only have one condition but I need to add a 2nd condition. Here is what I have for 1 condition:

=SUMIFS({Team DD - Budget - FY19-FY20- Amount}, {Team DD - Budget - FY19-FY20- Requester Hi,

I've been trying to use this formula:

COUNTIF(Due Date, MONTH(@cell) = 8, but it returns an error INVALID DATA TYPE

If I limit the data range to exclude the blank rows than it has no problems. But this is not pratical because later when I more tasks, I have to adjust the formula. Interestingly Hi there,

Wondering how to amend this formula so that if all the cells are "N", it will return a blank in column "Report Status"

=IF(OR([PAR Items]16 = "Y", Proxies16 = "Y", Commissions16 = "Y", Constraints16 = "Y", [APX Reports]16 = "Y", [MRFP/SMA]16 = "Y", Commentary16 = "Y", Attachment16 = "Y", There seems to be an error in my formula.  The first part works by itself (counting the number of times the SME's name appears).  Then, when I add the critieria to limit the count to those whose status is "Red", I get an "incorrect argument" error.  It is selecting the correct data sets to pull