-
Counting specific values in multi select cells
Hi All, I am trying to count how many offices have certain engagements (choices are Calls, Email, Weekly PF call, FB gorup, Other, Texts). These cells are linked cells from another sheet. I tried these formulas: =countif([Office Engagement:Office Engagement], contains("Calls", Office Engagement@row)) =countif([Office…
-
How do I add criteria to formula?
The smartsheet template I'm utilizing has a built-in formula for the status that is based off of the children... =IF(COUNTIF(CHILDREN(), "Completed") = COUNT(CHILDREN()), "Completed", IF(COUNTIF(CHILDREN(), "Not Started") = COUNT(CHILDREN()), "Not Started", IF(COUNTIF(CHILDREN(), "In Progress") > 0, "In Progress",…
-
Vlookup from Created Date column
Hello, I'm having trouble when I use vlookup from a column typed as "created date", every time a date is created after 6pm, my vlookup returns the following day, as shown in the screenshoot. Is there a way to fix this?
-
Return the row number(s) that a CountIf, SumIf returns as TRUE.
Hi team! I have a relatively complex countifs(yadda yadda yadda) formula telling me if something is wrong with any of the hundreds of rows in a sheet. Now, I need a cell to identify the SmartSheet row numbers where the countifs() is true so the sheet admin can navigate right to the rows that have problems and correct it. I…
-
Count the number of duplicate unique numbers
Hi, I have a column of unique numbers that I would like to track if duplicate entries occur. If a duplicate entry occurs I would like to pull the unique number into my metrics sheet and track it in a separate sheet; ideally id like the new column in the metrics sheet to include the duplicate unique number as well as how…
-
Logic based formula help needed if someone could help please?
I am trying to make my sheet derive a priority based upon the responses gathered from a form that is completed. Users will be selecting from a dropdown list of categories and, based upon their answer I want a priority to populate in another cell. I am not experienced enough to figure out how to build the IF formula (or…
-
REPORT NOT ABLE TO VISUALIZE MORE THAN 2500 ROWS
Hi, I have this list of entries, (each one has his ID) stored in a sheet, some of them are validated, some not. I have this other report where all validated IDs are shown, grouped by certain column (country). Once i have arrived to more than 2500 entries the report states: Now the question is, please tell me i dont have to…
-
Creating a category column based off sub-categories from a dropdown column
Hi, I'm looking to make a column which returns the corresponding category for sub categories in another dropdown column For example, I have column 1: The text/number column for writing a formula to return the category and column 2: the dropdown for which I have subcategories. In column 1, I have categories X,Y and Z. in…
-
Overlaps in Start and Finish dates
Hi Can someone suggest me a formula that alerts me whenever there are any overlapping Start or Finish dates across ALL the entries that I will receive in my Leaves Management app? For example, all the leave applications submitted by the user abc@xyz.com must not have any overlapping Start and Finish dates; and if there are…
-
A cell in a Source Sheet and link to Mutiple cells in a Destination Sheet
In my destination sheet, I want to link the values of a specific range of cells to A CELL in the source sheet. Is there quicker way to do the linkage? I tried to copy paste the format but the link does not apply to the rest of the cells.
