-
I'm trying to calculate the number of instances where only two items appear in a cell.
I'm trying to calculate the number of instances where only two items (the words content and functionality) appear in a cell. My current formula is not pulling the correct count. Any suggestions? P.S. I'm a formula rookie :) =COUNTIFS({Sub Type Update}, "Functionality", AND "Content", {PhaseForecast}, OR(CONTAINS("Planned",…
-
Searching within collected values from across multiple sheets
I am having trouble coming up with a way to search within values using a Collect formula. I have three sheets, one which shows the courses a user has completed, one which shows the courses included in each learning plan {CourseMapping_Course} {CourseMapping_Paths}, and one which shows the learning paths assigned to each…
-
Avgifs between dates
Hi SmartSheet Gurus, Not sure where I am going wrong here. I keep getting an unparsable error message
-
Sheet Reference Formula for Last Week?
I have a source sheet set up that has three columns: State, Delivery Date and =WEEKNUMBER from the Delivery Date formula. I have a metric sheet set up where I want to use a =COUNTIF formula to calculate rows from the source sheet with deliveries by state, and I want it to count by delivery date from the previous week (not…
-
I'm trying to auto populate a column with Monday to Sunday dates based on date from another column.
Example "Current Date" Column "01/08/24" "Week Of" column would auto populate "01/08/24 - 01/14/24" Current Date / Week Of 01/08/24 / 01/08/24 - 01/14/24 01/09/24 / 01/08/24 - 01/14/24 01/10/24 / 01/08/24 - 01/14/24 ~ 01/15/24 / 01/15/24 - 01/21/24
-
Formula to count unique value from single dropdown row
Hello, Im looking for a simple formula to count "Not started" values from a [Action Plan Status] column This is the formula im trying to use: =COUNT([Action Plan Status]@row, "Not started") Thank you!
-
Can I create a continuous date column?
Is there a way to make the a date column go all the way down so that it can act as a continuous daily log without having to enter the date every day?
-
Return Non-Blank Value
Good morning, Community! As IA Compliance20-24 will only have one value, I'm trying to grab that value into the green cell which is the summary of that section. Any thoughts? Thanks!
-
=IF(AND(HELP!
Hello! I'm having an issue in building a formula to trigger an approval request. Here are my 3 columns: [Current Pay], [New Pay], [Pay Increase]. Here's the scenario: IF the New Pay field is not blank, not equal to NA, AND greater than the number in the Current Pay field, the Pay Increase field should equal TRUE. Can…
-
Roll up based on selection from one column and count of answers across mulitple columns
I created a form to get feedback from 6 different business units regarding 48 different applications. The participants select their business unit name from a single select dropdown. They then rank each application as “Not Used By Myself or My Team”, “I'm Not Sure”, “Not Important”, “A Little Important”, “Somewhat…