-
Help with question for multiple approvers.
Hi forum, looking for your advice on a formula. I have a workflow that requires approval of Yes or No from multiple locations. Some changes apply to a few locations, and some changes apply to all locations. I have a sheet that describes the change and multiple columns for each location to capture their Yes or No approval…
-
Count Index Match Cross Sheet Formula
I'm pretty instantly stumped trying to make a count index match cross sheet formula. I want a count of the Quantity column associated with those primary column part numbers. I have separate sheets for 213, 214, 215. Here's a view of the 213 sheet: Ideally it would be good to incorporate the status as well but I'm not sure…
-
Cross Sheet SUMIFS by date and name
I want to use a formula to get a sum of a weight from a list on a separate sheet that matches a certain name and has a ready date that falls within a certain month. =SUMIFS({CFL & VL Product Stock List Range 1}, {CFL & VL Product Stock List Strain Name}, "Banana Baby", {CFL & VL Product Stock List Est. Ship Date}, "July…
-
How to count rows with more than one selection in a drop down menu?
Hello you pros, I looked for an answer but was unsuccessful. I have a column with a multi-select dropdown menu. The selections are for product categories in the cannabis industry (flower, edibles, concentrates, vapes etc) I have found a working formula to count how many projects have a single category (thank you…
-
Additional Code to be added
I have created the following formula to count the number of cells for 2 specific requirements =COUNTIFS({Reference Sheet 1}, Country@row, {Reference Sheet 1}, Name of topic) This gives me what I want but I now need to add new criteria that looks at another column which is a date and I only want to count where a date exists…
-
Nested AND/OR statement with COUNTIF
Hello, I'm trying to count the number of rows that fit this criteria: This is the formula I came up with but am getting an error. I'm betting that the problem is the placement of the ANDs? =COUNTIF(AND((OR({Retail Survey Launch Status} = "Operational", {Data Upload Status} = "Operational",(AND({Experiencia Rounding…
-
If formula looking at 2 different columns
Hello I am trying to write a formula that looks at two different columns on my Smartsheet and returns a value based on what is in the cells. I want to look at ticket location column and if value is "Complete" I want to return value "Implemented" Second I want to look at Fix Version Column and if it is blank return…
-
Timed Agenda
Meeting Agenda (Agenda Timeline Calculator) Does anyone have a template or a meeting agenda tool that calculates start and end times for each speaker? My organization holds a 2-day meeting that always gets off schedule. We'd like to be able to enter a meeting start time, then add each speaker's length (minutes) and have…
-
SUMIF or SUMIFS (multiple columns and YEAR and MONTH criteria)
Formula Logic (for the formula that would be a column formula for the Jan column - needs to be a single formula): SUM ([Received Count] if [Date Recd]'s YEAR = 2022 AND MONTH = 1) and also SUM ([Completed Count] if [DateCompleted]'s YEAR = 2022 AND MONTH = 1) Thank you!
-
Delta Date
Hello, I would like add a formula to add a date delta according a deadline For example: today 16-JUN-2022, my Deadline = 15-JUN-2022 so delta = +1 Today 16-JUN-2022, My Deadline = 10-JUN-2022. so delta = +6 Could you help me for the formula please
