-
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…
-
Give a Rating of 100% if checkboxes with different conditions
Hello everyone, this is my first post and I hope I could get some help. Im trying to create a formula with the following conditions: 100% rating if the YES chechbox is marked 100% rating is the N/A checkbox is marked 0% rating if the NO chechbox is marked
-
CONTAINS to count cells with specific string of numbers
Is there a way to use COUNTIFS and CONTAINS to count cells that include a specific string of numbers as well as cells that include that string plus something else? In the example below, I'm trying to count the number of students who are taking the course with the Code "20659," which should include those taking only that…
