-
Edit formula to return a blank result if the result is zero
Can you tell me how to edit this formula to return a blank cell instead of a zero? It is putting zeros on our dashboard graphs/charts that I want removed. thanks!! =COUNTIFS(Header:Header, 0, Status:Status, "Yellow", [Current Phase?]:[Current Phase?], "1", Level:Level, "1")
-
How to do Weighted AVG in smartsheet?
We are having a feedback that tells us the rating per questions, as the image shows, it has the number of counts per rating. Now, how do I get the Weighted Average if the number of respondents of the form keeps changing since it is an ongoing session (daily)?
-
Half day vacations
Hello, I built a form for my department to request and track their vacation days. The standard data includes date of request, start date and end date, as well as, adjustment days to exclude holidays from their remaining allocated vacation days. However, some are asking for half days, I put a checkbox in the formula but how…
-
Creating and maintaining a graph of values from several sheets
I want to graph a specific set of values from a number of project sheets. Each project has it's own sheet and there are certain values associated with the project that I want to show as an aggregate graph. So using "Percent Complete" as my example, for 20 projects I'd like to show a graph of the distribution in terms of…
-
Amount in negative
Hello, How can I show the amount in negative when the status changes. For example, here in the screenshot, the red highlighted one has the status 'OUT'. I want the amount to show in negative in the next column. Thanks
-
% Complete Forecast to Future Date
Is there a way to project a POC (Percentage of Completion) to a certain Date? The assumption is that the baseline schedule has been vetted, and agreed upon. What I would want to do is forecast for example what the POC would be to the end of the Month, or to the end of the Next Month - I'm at May 30th right now, so I can…
-
Value if cell contains text
Hello everyone, I'm french so sorry for my english... I want to return the city name if the "Territory" column contains T1 or T2... Knowing that I use a correspondence sheet: T1 = PAU; T2 = Toulouse; .... =IF(ISBLANK(Territoire@row); ""; JOIN(COLLECT({City name Plage 3}; {Correspondance Territoire Plage 4};…
-
SUM and INDEX combination formula
I have this formula that works in Excel, but when I try to rebuild it in Smartsheet, I'm getting an error that it's unparseable. How can I do this in Smartsheet: =SUM(C3:INDEX(C3:N3,$C$2)) I've gotten here in Smartsheet, but it doesn't work: =SUM(January@row:INDEX(January@row:December@row, 1, $January$1)) I would like to…
-
IF, AND formula for checkbox
Hello, I'm trying to make a formula for a checkbox column where if the column titled "Expected result" is positive, but the "Results" column is negative, then the checkbox will be filled (and vice versa if expected is negative and result is positive). However, I cannot say if the expected result column and results column…
-
need to have a formula auto fill but only if there are dates in specific cells
I am trying to get the cells to auto fill depending on the dates entered next to it. I can't use the convert to column formula feature because it's not a guarentee that all data in the start date and end date will be entered. We are doing a market review for a certain group of team members and need to let them have the…