-
Using IF with greater than or equal to a number
I want the "Complete" column to show "yes" if the total reviews is greater than or equal to 3. I cannot figure out what I did wrong with the formula above. Thanks!
-
Nested ISBLANK Formula
Hi I want to be able to look up changes to e.g. employee name, Job Title etc in a sheet and update the any changes on a staff sheet. However, if for example, their job title hasn't changed I need the formula to refer to 'old job title' column. I have a unique identifier of the Employee ID so, wondered if an INDEX MATCH…
-
Using HAS with Multi-Selection Dropdown
Hi, I have a multi-selection dropdown with region selections. Next to that column I have the regions. For reporting purposes I need the column for each region to say "Yes" or "No" based on the items selected in the multi-select dropdown. I've created this formula with a variation for each column: =IF(HAS("Central",…
-
Ignore blanks while detecting matching text across multiple columns
Hello! I am trying to write a formula for detecting ANY matches between "Affiliation" and "Affiliation 1," "Affiliation 2," or "Affiliation 3". If any of them match "Affiliation", then "conflict" is true. If false, it should say "none". However, if "Affiliation" is blank and matches another blank, it also outputs…
-
Summing values for a specific date from a date range
Hi all, I have a project sheet with Start and End dates for tasks, as well as a Percent of Team's Time column that tells me how much of my team's capacity will be used on that task. I want to sum up how much of my team's capacity will be used on any given day, since there are multiple tasks with overlapping date ranges…
-
Need Formula help
Hello, I need a formula in order to calculate the sum of specific hours for a resource on a particular week with a certain criteria. For example, I need the formula that calculates the hours for Jane Doe for week ending 4/2/21 charged only to Department A. I tried something with SUMIF or IF(SUMIFS but couldn't get it to…
-
Guidance requested- Count if two drop downs options are both selected in one cell
Hi I'm trying to get a count of the number of times 2 specific dropdowns are selected in a given cell in a specific column, where the project line item does not have a specific dropdown selected in separate timing column. e.g. count the number of instances where the [Sequencing Dependencies] column has both "Dropdown…
-
Sum Row with Current Month for Metric Widget
I've search and tried this so many different ways but cannot figure this out. Basically, I want to create a Sheet Summary Field that totals the row for the current month. I thought creating a helper field and index formula would do it - but can't get it to work for some reason. I think I've over complicated it, honestly.…
-
Validating data input in a Form
I have set up smartsheets to collect data with forms for the users at our facilities. The operators check equipment and enter the data in the form. Sometimes, they fat finger it - or forget the decimal point which causes an out of spec condition and email notifications. Is there any way to validate the data and the user…
-
Column Number Function
Hi is there a function that can return the column number when given the column name? This would help when columns are added in sheets that have vlookups referencing them.