-
Total Entries on a Sheet
I'd like to keep a running total of entries on a sheet. I thought I could do it with a countif not isblank formula pointing to the primary column (so text/number field) but It's returning 0 and there are many entries so I know it's wrong. Is there a better way to do this that I'm not thinking of? The formula I was using is…
-
Issues with autosaving data
It appears that items are not saving or following the one minute save rule. These issues have occurred in date range cells as well as check box cells. My thought is that this could be linked to a iOS 14 beta issue. At this time, I have only noticed this occurrence with absolute certainty twice. Here is the current software…
-
Help Needed: Adding or multiply 2 cells with formulas
Hi team - I have a simple 4 column sheet I'm trying to test nested IF functions returning a predefined answer and then sum up or multiply the 2 "scores" together: Impact options: No impact, service continues at full capacity Service is limited to 75% capacity available Service is limited to 50% capacity available Service…
-
Return multiple cell data with a VLOOKUP or INDEX MATCH
Hi, I am trying to return the text within multiple cells based on criteria of an adjacent cell. In this example I want to return JOINED cell information from any the [News / Key Information / Highlights] column cells that matches 'NEMEA" in the [Region / Dept] column ( Ialso want to add in the criteria of being in the…
-
COUNTIFS with vLookup Results
When i reference the VLOOKUP fields in the COUNTIFS formula, I get this error #NO MATCH. =COUNTIFS([Server Install Status]:[Server Install Status], "Installed", [In Scope]:[In Scope], "Yes") The [Server Install Status] column is populated with the results of =VLOOKUP([Server Name]1, {cmdb_ci_win_server20200810 Range 1}, 3,…
-
COUNTIFS Formula to pull submissions entered on a Weekly Basis (Sun - Sat)
Hello, I would appreciate anyone who can please help with the formula I have below: =COUNTIFS({Facility}, "Sumner", {Inspection Date}, >=DATE(2020, 8, 9), {Inspection Date}, <=DATE(2020, 8, 9)) Essentially I want to count the number of submissions or rows I have from a specific location from another sheet from Sunday to…
-
Create multiple rows based on data from one cell
I need a way to count the number of states each project participates in. For example, for Project A I should be able to says West Va and Va. Smartsheet will not allow me to count the state column. So I would then like to be able to separate each project by row based on the state column. I found VBA code to use in Excel to…
-
Roll up summation of multiple sheets
I am trying to create a budget sheet that roll up the information inputed by mangers on 10 different sheets. Each manager has a grid like the one below and I want to duplicate that as a summation of information from each sheet. So a summation of the #of trips for a conference across all the sheets would need to go in the…
-
Why are my Parent rows constantly expanding when the Filter is turned on?
Hello, All of my Parent rows are expanding automatically when I have a filter on. This happens every time a member of my team refreshes the page. Is there a way to have my filter on and keep the Parents rows from expanding automatically?
-
IF Formula doesn't work
Please help, what's wrong? It couldn't be parsed... =IF(OR([Исполнитель (из первичной)]4 <> Исполнитель4); ([Стоимость работы (с НДФЛ) (из первичной)]4 < [Cтоимость работы (с НДФЛ)]4));"ДА";"НЕТ") Thank you in advance.
