-
I need help with a count formula
Hi All, I need help with a Count formula. I columns that have a 3 option dropdown and I want to report on the number for each using a formula (Countif /s or any other formula). I am happy to setup 3 separate formulas for each of the 3 options, so don't need anything fancy. Just need help creating a formula that counts the…
-
IF, OR, Populate Statement
Hello everyone, not sure if this one is possible, but I'll give it a go. I want to create one formula that basically functions as below: IF([3MO Left Target Amputation]@row="Yes", Insert Date from [3MO Maj Amputation Left Date]@row),IF([3MO Right Target Amputation]@row="Yes", Insert Date from [3MO Maj Amputation Right…
-
Self-updating report based on sheets in folder
Hi there, Is there a way that I can build a report so that when a new sheet is added to a smartsheet folder, the contents of the sheet then automatically gets compiled into a report? I saw that it was possible to select a folder when building a report, which I was really hoping would have that functionality. But it looks…
-
Moving a group of rows to complete sheet
Hi! I am creating a month end checklist for our Accounts Payable dept. My idea is that all rows are visible even if checked off until the final Month End Close Complete is checked. After this, Row 1-55 would be moved to a completed sheet and a new month would start the exact same way. I cannot figure out how to move a…
-
IF statement returns formula statement, not value of formula
I want the value if true, value if false in my IF statement to return the results of 2 different formulas. But if returning the language of the formula itself on the value of the formula. I need this cell to show how long a position has been open, and if there is a position fill date, how long it was open before being…
-
SUMIFS Formula Returning 0
Hi, I am doing a simple SUMIFS formula that is returning zero instead of the actual sum. Just for reference, the numbers in January's column are manually entered. The zero in February is where I am testing my formula. I have rearranged this formula so many times and it still returns zero instead of the $585. =SUMIFS([Grand…
-
Need help fixing this
=COUNTIFS({Behavior Based Safety Observation Range 4}, OR("no action need","complete", @cell)), {Behavior Based Safety Observation Range 2}, CONTAINS("STS - Operations (welding)", @cell)) First one i want it to count no action need or complete the second count welding department entries
-
Alert (Red, Yellow, Green) comparing Harvey Balls to Expected % complete
Hello. I received a great formula by someone in the community to help me set up a column that would automatically alert red, green, or yellow comparing Harvey Balls to our Expected % Complete but it is showing red if our Harvey ball is showing ahead of the Expected % Complete and it should show green if we are ahead of…
-
Remove health from Project Level row
Hi! I'm trying to remove the health function from the upper hierarchy/project level row in my project plan. The way I have it set up will give a health of Red if the due date is past and I only want health at the phase and task levels. Do you have any suggestions for how to edit the formula? =IF(ISBLANK(Status@row), "",…
-
Multiple IF + IF(NOT
Hello and happy New Years to everyone, I am a little stuck on a formula and would need your help. Here is my formula: =IF([Column2]@row = "France", IF([Primary Column]@row = "Value 1", "Value A", IF([Primary Column]@row = "Value 2", "Value B", IF([Primary Column]@row = "Value 3", "Value C", IF([Primary Column]@row = "Value…
