-
Same Formulas & Invalid Data Type
Hello, I hit a bit of a snag and was wondering if anyone could help me out. I have this metrics table that I am using to create a roll up based on the root causes and the month it was created (image below) Each of these cells has a roll up formula that's supposed to remain consistent: =COUNTIFS($[Cause of agedโฆ
-
How do I sum a range for a contact when the contact is in a column that allows multiple contacts?
I tried =SUMIF(Owner38:Owner59, Owner@row, Duration38:Duration59) but this only works if the Owner is the only name selected in the cell. If the Owner is included with another name in the cell it doesn't find the owner. Formula returns 2 instead of 12
-
Nested If Formula
Could someone please help me with this IF formula? Much appreciated! =IF([Total Individual Miles]1>350, "Five", IF(Total Individual Miles]1 <= 50, "One", IF(AND([Total Individual Miles]1 >50, [Total Individual Miles]1 <=150), "Two", IF(And([Total Individual Miles]1 >150, [Total Individual Miles]1 <=250, "Three",โฆ
-
Approval Requests overwriting Formulas and Column Formulas
Previously, a formula typed into an approval column would be overwritten when the approval workflow was run. However, the admin would have to manually add the formula back to the top or bottom row to be carried into the next entry, if additional row entries hadn't copied it into new rows. With the new column formulas,โฆ
-
Sum based on the status of a check box
Hello! I have found another discussion on this topic, but it didn't quite get me where I needed. For the Sheet Summary data, we are looking to see the total of all of the kits needed and to have this number continue to reflect the "current" need as lines get marked complete ... so we only want it to count lines that areโฆ
-
Adding
Hello, I am looking for help in smartsheets. I use it for work as I heard it was just as good, if not better then excel. However, so far I find Smartsheet really hard to use and understand. I have been making budgets, chats, etc for a couple years in excel and I am pretty good at it. However, when I use Smartsheet I feelโฆ
-
Column Formulas in SUMIFS
Hi there, I'm currently using a SUMIFS formula that is as follows: =SUMIFS({v4 Hours}, {v4 end}, MONTH(@cell) = 12, {v4 Group}, OR(@cell = "AD", @cell = "Freelancer")) I want to sum the task hours column {v4 Hours} if the End Date for the task is in December, and the group has one of 2 values. Each {reference} refers to aโฆ
-
Conditional Formatting: Comparing one Date column to Another
I am trying to setup a rule to format a date Red if it is different from another column. For Example, I have two end date columns, the New finish date is the active date but I want to see where this is different from the Old Finish date we had previously agreed upon. Old Finish Date New Finish Date I want new finish dateโฆ
-
Another if statement formula
I have what I thought would be a simple formula: =IF([Total credits per tuition year]@row > [Permitted credits per year]@row, "True") the formula is parse able; however, it's returning true whether the total credits per tuition year are greater than the permitted credits or not, except for the first row. The first row isโฆ
-
I want to add columns with checkbox ticked and return a number
What would be the formula to calculate checkbox ticked and return a number 2 when checked 0 when unchecked? Thanks