-
Formula help
hey guys, i need some help creating a formula that will pull through the amount of type A i have delivered month. Thanks in advance, Katie
-
Formula Help
Hey guys, I need help to put a formula in my sheet that can sum all 'Type A' column that are from a specific campaign and specific market. for example all total of type A for Jazz (campaign) AT (market) I thought it would be something like, but neither are working =SUMIFS(Campaign:Campaign, "Jazz", Market:Market, "AT",…
-
Trying to return a value using if and statements but get Unparseable so Help?
=IF(AND([Due date 2023]@row > TODAY(), ISBLANK[Completed 2023]@row), "yes", BLANK) This is the formula which I think is pretty simple but I'm trying to get a yes if the date from due date column is greater than today and information has not been submitted in the completed column. Feedback is appreciated
-
IFERROR(AVERAGEIF(REFERENCE ANOTHER SHEET
Hi all, Looking for some help on a formula that I keep getting an error. I am looking to populate the average % into a breakout summary sheet by referencing multiple columns from the master sheet, but only if the Master QTR column contains a specific quarter (i.e. Q1). I was able to figure out how to populate the average…
-
Help with Formula Vlookup, collect, if?
Not sure if this is possible but I have a sheet to track monthly billing and another sheet to forecast milestone completions. On the monthly billing sheets I want it to look at the milestone forecasting sheet and if a milestone is forecasted to complete in a month add a billings to the billing sheet. Billing sheet looks…
-
How do you calculate an average on a column that also contains "#Invalid Data Type" in some cells??
I have a column of numbers (days duration) between two date columns but, in many cases, one of the dates may be missing which gives me an #Invalid Data Type entry in the column where I am averaging the days duration. Attempting to average the column, I don't know the syntax to skip over the #Invalid Data Type cells to only…
-
Count Year and Month Only from Separate Smartsheet
Hi all! New smartsheet user and learning formulas! I'm trying to count the number of jobs in a month per project type from a separate smartsheet (to eventually be turned into a graph). The date format in the original smartsheet or month/day/year. I just want to count the month + year. The Project Type is also in a separate…
-
Determine if items in multi-select dropdown match items in another list
I have a sheet 1 with a multi-select dropdown, eg, multiple names in one cell. I have another list of target names on a separate sheet 2, and I want to check which rows in sheet 1 contain the names on sheet 2, and how many names match in each row. So for example, if row 1 of sheet 1 contained the Names cell: Bob, Doug,…
-
IF(AND( Formula Calculating...half correctly
See above for reference. I cannot figure out what is wrong with my formula. My goal is that the Flag is "checked" anytime the second column of dates (named End Date/Ship Date) is within ten days or later of todays date, AND the status column is anything not matching Complete..... Completely brain dead after going at this…
-
Check room availability for same date.
Hello Smartfamily ! I have a sheet where I need to check if a room is available for the same date. The screenshots below shows how the column "Availability" SHOULD behave. ----- For the date April 24 2023, I select Room 1. Room 1 is not already selected for that date so "Availability"@row shows a checkmark As soon as I…