-
Multiple IF Statement Returning Different Text
Hi Everyone, I am trying to write a formula that will look at a cell and if certain wording is not in the cell then return a value to a new cell. The information is from a multiple dropdown selection column. Here is an example of what i am trying to do. Dropdown List Would Populate the Missing Color column based on a…
-
Network Days + If statements
Hello, I'm trying to build a formula that will show the network days between a [Start Date] and an [Completion Date], but also 1) if [Start Date] is blank, then return a blank instead of an #Invalid Data Type error; and also 2) if [Completion Date] is Blank, the formula subtracts the [Start Date] from Today(), so that we…
-
Formula to calculate Next Due date
I have a column that calculates Due date (a yr in advance) and in a different sheet it's compiling by name of person, Due Date and how many they have accumulated so far. I want the column of DUE DATE to give me the next Due date - Today. Meaning if the Due date falls on TODAY then it removes it from the formula. this is…
-
Index Match Returning the Wrong Value
I'm perplexed why the Index(Match() formula might be returning the wrong value for me. I've checked this at least a dozen times and I have no idea. Please see screenshot below: =INDEX({Sell Rate}, MATCH(Position@row, {Position}, 0) It should be matching the sell rate in this other sheet when the position is Test. As you…
-
formula not showing Dollar symbol
I have column (B) join collect Items @row. I have Column (C) join collecting multiple Column (B) items based on unique values. =JOIN([Cost Center]3:[Rec'd Approval From 2]3, "-") I would like to have the dollar symbol in Column (A) to be present in columns (B) & (C) =IF(ISBLANK([unique.invoice]@row), "",…
-
How to count values if either of two conditions are true
I have two sheets: Sheet A and Sheet B I would like to count the number of cells in Sheet A, Column A and Sheet B, Column B that have the value "Liver". Both sheets are stored under the same folder.
-
Need help with adding a new row in a sheet and for the new row to reflect in the destination sheet
Hello friends, Here's my scenario: I have a source sheet (master data), and I have a destination sheet. I'm using data mesh so that data is pushed from one sheet to the destination sheet. I will be using one of the sheets which consists of numeric scenarios (parent) and multiple steps / tasks under each scenario (child).…
-
Moving from 2023 to 2024
In 2023, our data was recorded by regions which then produced a President's report and Dashboard. Beginning in 2024, the data will be recorded as one company and not by regions. My sheets were originally set up with the help of a Smartsheet Professional so I am not sure how the formulas in the background are set up and how…
-
I need to count the number of enquiries between the dates 01/01/2023 & 31/12/2023
I need to count the number of enquiries between the dates 01/01/2023 & 31/12/2023 Just can't get the formula right, keep getting Invalid or Unparsable, I know it should be straight forward but...currently trying to use COUNTIFS I have the formula to count all the values that equal enquiry but can't set it to select between…
-
Sum of all values from a column X in a sheet A into a sheet B using index/match
Hi I have two sheets, one is Allocations and other is Rollup, Allocations has the following columns: Resource Name, I can several rows with the same value January 1 January 2 .... December 31 In Rollup I have the list of unique names listed in a Resource Name column, and also the same columns as Allocations. What I want to…