-
Formula incorrectly stating two cells are not equal
I have two columns, one is an index collect formula and the other is a simple subtraction of two cells. I want to create a formula to display a message if the two cells are not equal. I created the following formula '=IF([UOB QA]1 <> UOB1, "Check UOB")' and as you can see below, the two columns are identical and it's still…
-
Automated Drop down or Formula?
Hi all, I was wondering if there is a formula or drop down function that can auto populate words or drop downs? As seen in my conditional formatting for "Days Left Till Expiration it conveys whether if it is red, Yellow, Or Green based on the amount of days passed or upcoming till a Term end date. I'm wondering if I can…
-
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!