-
IF(FIND Function with AND
Hi Everyone, I have created a formula which works well with locating and counting text in a range - "COUNTIF([Functional Area]:[Functional Area], FIND("Accounting",@cell)>0)". This formula counts the total number of items irrespective of the status of the item, which could be for example, New Demand, In-flight, UAT,…
-
COUNTIF with Todays date changes on full sheet load
G'day I'm having an issue when using =COUNTIF with a submitted date. I'm trying to count the number of submissions to another sheet for; Today, the last 7 days, the last 30 days, and so on. The calculation seems to be working, but the number changes very quickly after the page loads. For example, shows the count as 8, then…
-
How to remove duplicate strings in two columns (Two adjacent cells) then add into another
Column 1 Dog Cat Mouse Column 2 Dog Cat Pig Column 3 (result) Dog Cat Pig Mouse
-
Mapping values in a multiselect field
I have a form that gets submitted with a multiselect field, and I want to map the values in that multiselect to other values in a mapping sheet. So if a user submits the form with 'San Fransisco, Paris', the formula would return 'USA, France' based on the mapping table on the lefthand side of my screenshot below. What is…
-
Grouping not sorting correctly on numbers? Does anyone know why?
The grouping of numbers works fine until you get to number 11. Background: I have attempted to sort by month and knowing there is no logic to sort by month (as dropdown list) I have instead opted to use numbers as a prefix to each month. Unfortunately this causes an issue when it gets to 11. My team is loving this grouping…
-
Date Formula Issue
=DATE((YEAR[Tactical Training Start]@row), (MONTH[Tactical Training Start]@row) + 1, (DAY[Tactical Training Start]@row)) ^^ This is the formula as it sits now. I'm trying to take the date from the Tactical Training Start column for a cell and add 1 month to the date for a different cell. What am I doing wrong?
-
Trying to create a formulated/formatted sheet from the inputs of online Form
Hello. I am stuck here. I created a form. In the sheet file, I have some formatting and formulas to run reports based on the inputs coming from the online form. However, when a new input comes into the sheet as a new row, my formats and formulas that I set up in upper rows do not apply to this newly created one!. I have to…
-
Trouble with Countifs formula across sheets
I'm pulling data from one sheet into another to total a few items. I've attached screenshots. Sheet one is where the formulas are located, sheet 2 is the original data. I'm using a helper column for the week and Countifs to count how many appointments meet the criteria. Here is my formula: =COUNTIFS({Assigned Agent},…
-
What formula if I have two variables
Hoping someone can help me with this one. I need a formula to show totals by GEO and booked/non booked. If the Sales Order Number is blanked, it's not booked and i want a total by GEO for pipeline. If the Sales Order Number is non-blank, then I want a total by GEO for booked. When I'm done, i want on a seperate sheet:…
-
Help with formulas to have data in the Summary Sheet
Hey Paul, I have created the below individual reports for the upcoming tasks in the Smartsheet. This has a combination of Tasks + Country + Owners + Status. However, I also need this data in the Dashboard. Could you please help me with formulas to have this data in the Summary Sheet? So that I can pull the data from the…
