Formulas
Discussion List
-
How to create this COUNTIFS with AND/OR/NOTIn Formulas and FunctionsI cannot figure out how to create this formula to get the metrics. I can get each individual dept metric correct using =IFERROR(COUNTIFS({(Phoenix) Project Tracker - Aerial Status}, AND(@cell <> "No", @cell <> "…
-
Linking Two Sheets to update dynamically When columns are added and removed.In Formulas and FunctionsI have two sheets that i want to be linked dynamically. EX: Column 1: 1 2 3 4 5 I want to be able to have this column automatically update and be created on the second sheet when it is changed on the first. If for example, I were…
-
How to keep a cell blank if there is no data?In Formulas and FunctionsI have two sheets a master (2800 records) and a feeder (270 records). I am using the following formula to update a column called scheduled date on the master: =INDEX({feeder06262021 Range 1}, MATCH([email protected], {feeder06262021 Range 2}, 0)) Wh…
-
Searching formula for index/match, searching for matching value on multiple sheetsIn Formulas and FunctionsHello all, I'm a newbie and am getting stuck trying to find the correct formula to return an ID associated with a person when searching for this person across multiple sheets. I'm familiar with INDEX/MATCH, but am having trouble figuring o…
-
#INVALID OPERATION ErrorIn Formulas and FunctionsQuestion: Is it possible to write a SUMIFS column formula to add up specific cells in an adjacent column where the criteria are also in other adjacent columns? (Actually, I know it's possible, because the formula I wrote a couple days ago …
-
Search on a text string to return all valuesIn Formulas and FunctionsHello My Fellow Smartsheet Gurus, Is it possible to run a formula based on the text inputted in the column next to it to pull all possible values? I am trying to accommodate multiple ways of finding medication names where an exact match i…Answered - Pending Review 3 views 1 comment 0 points Most recent by Andrée Starå Formulas and Functions
-
How to combine multiple rows of data into one row based off of one cell value.In Formulas and FunctionsHello Smartsheet's community! I am back with another question. I have a database that holds the tracking of employee trainings. The training structure is in tiers and after each completed tier they fill out a form. The raw data from this …
-
Countifs OR Formula IssuesIn Formulas and FunctionsI am doing a countifs formula, and am unsure how to include an OR formula. In the Summary Program column located on another sheet, I want it to count the number of both Bi-Annual and EMEA cells. for rows which Summary Season is S21 This i…
-
Formulas for % Allocation in Resource ManagerIn Using SmartsheetIs it possible to use a formula to generate a percentage in a % Allocation column for use in the Project Resource Manager? Or does a percentage have to be manually entered into the % Allocation column? I've done quite a bit of research on …
-
Workflow - recognising email domain as part of "assigned to" columnIn Formulas and FunctionsHi all, I have two columns: Assigned to - this is set as the "contact list" property and linked to the address book so you can put an email address e.g. "[email protected]". However in the field it wou…Answered - Pending Review 12 views 1 comment 0 points Most recent by Genevieve P Formulas and Functions
