-
How to use 'countif' with 'contains'
In the attached example, I would like to count all softwares that used 'Dimensions' (either Dimensions only or Dimensions together with other software). Does anyone knows the exact formula for this?
-
How do I create a IF(AND formula combining multiple cross references?
In this screenshot I am sharing my rollup data sheet. Of the 6 Total Amex CB Count, I am trying to determine how many of those each of our Branches has but I keep getting different errors using formula: =COUNTIFS({Dispute & Chargeback intake sheet branch}, CONTAINS([Data Points]32, @cell), IF(AND({Dispute & Chargeback…
-
Invalid Value Error in some rows of a Formula Column
I have an inventory transaction sheet that I have been working on for a little bit now. Looking at my Stock Alerts column again, it looks like there is an issue. The purpose of this column is to alert if the quantity requested is greater than or equal to the current quantity. If there is an error, then flag that the item…
-
COUNTIF with specific text
Hello, I am trying to do a COUNTIF formula that counts the number of cells that have the "gap" in the text. My current formula works but I would like to modify it to count cells that just contain the word "gap" and does not account for capitalization (I.E. can pick up on "gap", "GAP", "Gap" etc. . How can I include that?…
-
populate value within the same ID number with multiple criteria
Hi, I'm trying to create a formula that will populate Column Outcome (example highlighted in red). Within the same ID#, it'll populate the assignee based on: 1.) Within the same ID #, if column 5 has a %, and the assignee is not Sam, it'll populate the assignee name within that ID # 2.) If it's Sam, then it'll look at…
-
Internal Rate of Return Formula
Smartsheet leverages quite a number of formulas from Excel but does not use IRR (Internal Rate of Return). Would like to see IRR used in Smartsheet so that we can incorporate our Return on Investment spreadsheet in Smartsheet. Tyrell
-
collecting live information on a specific date
Hello community, I have a drop down column with stock status. It changes almost daily ; I need help creating a formula to count each status on the last day of the month (it could be the first if it's easier, 30th vs 31st as opposed to 1st). How do I do that? I know how to create the formula to count but sometimes I'm too…
-
Pull multiple IF THEN statements from data sheet?
I have a data sheet with 4 Columns that I'd like to pull into a second. In this simplified example, the Data sheet shows phase, activities which repeat for each phase and a date. I also have a column with "Yes/No" if I need the date in the Smartsheet. What formula do I use to get the data to my second layout? I'd like it…
-
Flags using IF AND formula with multiple sheets
Hello, I would like to create a formula where it flags for the following information: Donor Center = other sheet column Donor Center AND Job Title = Ops Admin QAS AND other sheet column Position = Quality Assurance Supervisor Then Donor center = other sheet column Donor Center AND Job Title = Ops Admin Assistant Mgr AND…
-
I am having trouble using "And", "OR" & "Countif(s)" to build a formula.
Hello, I am attempting to come up with a sheet summary formula that counts cells if they meet at least one of 3 different statuses in the same column, AND also meet one of 5 different statuses in a separate column. So using the screenshot I've provided as an example (although it doesn't have 5 different statuses in the…
