-
"The source data for this chart has changed" - Charts with Zero Values
Hello. I have noticed that charts within a dashboard do not display and throw up a message: "The source data for this chart has changed" when they are pointed at sheets or reports where the value is zero / 0. This is problematic for me since I have created a dashboard for a template set of sheets and reports, and…
-
Sums, IF statements and parent rows -- combined in one formula
I'm struggling to figure out how to combine two formulas. Context: my team doesn't like to think in hours, just general size of a task (S, M, L,) so I've created a helper column where each value relates to a number (XS = 1, S = 2, M = 4, L = 8, XL = 16), and an IF statement to return the values. This formula works fine in…
-
Formula optimization
Hello, I am trying to optimize this formula, do you have any idea? Thank you Chi =SUMIFS({Line Value}, {PE}, [PE Project Engineer]@row, {Status}, " ", {Backlog - Sales Orders - RTM Status}, <>"Complete") + SUMIFS({Line Value}, {PE}, [PE Project Engineer]@row, {Status}, "Approved", {Backlog - Sales Orders - RTM Status},…
-
How to track items that are completed after their due date
Hello! I'm trying to track tasks that are completed after the due date. I used this formula to indicate when an task was past due and not complete but once the task is checked off as complete it no longer works, well it works it just doesn't give me the data I'm looking for. =IF(AND(TODAY() = DUE5 + 1, Done5 = 0), 1, 0)…
-
Formula Help
Greetings- I'm struggling with the cross-sheet referencing and need some help with a formula. I want to create a new sheet summarizing the values on a corresponding dropdown menu for the name and # of products we sell. I'd like the total number sold for each dropdown choice displayed on the new sheet. In the screenshot,…
-
Finding duplicates in a column with multiple product #'s
Hi, Is there a way to find duplicates when a column may contain multiple product numbers which are comma separated? I was able to get the below formula to flag red when only one event number is duplicated in a one to one ratio, and also have the formula disregard blanks. Any ideas if there is a way to find duplicates when…
-
Looking for Smartsheet Consulting Expertise - Charlotte NC or Atlanta GA
We are looking for a Smartsheet freelancer that can help develop additional reports and dashboards. Prefer local to Charlotte NC but open to telecommuting.
-
Risk Assessment formula conversion from excel to smartsheet
I'm trying to convert an excel formula to use in smartsheet without much success. The excel formula is: =IFERROR(MATCH($F4,'Lookup Table'!$B$3:$B$7,0)*MATCH($G4,'Lookup Table'!$B$3:$B$7,0),"") In short, I need the 'Risk Matrix' column in smartsheet to show the score where the probability and impact rating intersect. I…
-
Date cell is not calculating correctly
I have a sheet where I want to add 30-days to another cell that is a date. I am using the formula: =(original date cell) + 30 Example: The original cell has a date of 3/19/19. I should get 4/18/19. However, I'm getting 3/19/1930. I have cleared the cell contents, deleted the row, and whatever else I can to create a clean…
-
Formula RYG automation with using Complete% and rest of date by end date.
hi I'm trying to create Formula. It's almost completed. However, one last rule doesn't work. Can someone suggest to modify my formula? Currently the following conditions and formula is working fine. - If Complete% is 100% = Green - If Complete% is upper 60% = Green - if Complete% is under 60% and Today is less 5…
