-
VLOOKUP on column with letters and numbers results in #NOMATCH
I have a simple VLOOKUP to pull back the related column from a 2 column table. It consists of either letters only (WORD) or numbers only (123) for each entry but entries span both types. When the function is in place I receive a #NOMATCH error for all the letters only entries. I've tried adding a helper column that refers…
-
How to calculate the number of teammates who will have a birthday in the last 7 days?
We are using TODAY() formula to define our teammates' birthday as below snapshot, but how can we use the formula to calculate the count of who will have birthday in the coming 7 days in summary? Thank you!
-
Unflag after marked completed
Hi, I am new to formulas. What can I use for the following: I currently have this formula to flag an over due task: =IF(AND([% Complete]@row < 1, [End Date]@row < TODAY()), 1) The formula on top works fine, but when the user clicks on the completed checkbox the red flag still appears. I want the red flag to disappear when…
-
COUNTIF with keywords
Hello, I am trying to set up a formula to count a cell if it contains a certain keyword (e.g. "communication"). The cell itself won't be only composed of that word, but will just contain it. My formula so far is =COUNTIF([Job Classification]:[Job Classification], CONTAINS("communication", [Job Classification]:[Job…
-
How to Use SUMIF Function for Sheet Summary
Hello! I am trying to use smartsheet to support budget tracking. I'd like to summarize the amount spent and section by our spend category. So if my Cost Center Category is equal to "Paid Media" I would like a sum of all rows meeting this criteria. So my range headings are Cost Center Category and Amount, my Criterion is…
-
is it possible to index a column from a different sheet if you dont have a value to match it with?
im trying to work around the 500 cell linking limit, which makes a lot of manual effort. i would appreciate any help.
-
Adding "Created by" column is auto populating every row with my name
I have a Risk Register with about two dozen rows of data. I want to add a "created by" column, so I can track who is entering risks. But when add the column and save, my name is appearing is all the rows as if I entered all the risks, which I have not. I'm thinking there is no way around this, is there?
-
Totaling a column
How can I get Smartsheet to total up the cells in a column that are not blank?
-
Is there a way to change a status cell based on multiple date criteria?
I am looking for help get the below equation to behave like I want. Currently it gives me #INVALID OPERATION, which I have trouble shot and determined it is giving me this because it is trying to perform logical operations on null values. The formula works if I populate all of the below date columns, but that isn’t how the…
-
Help Searching Mutiple Job#
I want to be able to insert in my table the information: PO,Project Description,Customer,Payment Teams,Business Unit,Submitter,Notes from anothe sheet that contains the Job information. From the Job# column, I've done it before with an index match but only when is one project. I want to be able to do it for multiple Job…