-
Return Multipe Cells
Hi Smartsheet community, I have the following columns: [Name] (text/number value) [Team] (drop down value) [Budget Milestone] (checkbox) [Program Milestone] (checkbox) [Project Milestone] (checkbox) Now I am unable to run a report because the what in report builder condition is either all 'OR' or all 'AND', not all tasksโฆ
-
Furmula Not Working Properly
In the following Formula if I use ="Completed" I get the correct Count back.ย If I change it to <> "Completed" I get 0 returned where it should be 37. =COUNTIFS(Status:Status, <>"Completed", [Due Date]:[Due Date], >DATE(2018, 11, 25), [Due Date]:[Due Date], <DATE(2018, 12, 3)) Any ideas? Thanks, Bill
-
SUMIF using a cell with a formula in it
OK, so my formula is this:ย =SUMIF([Customer PO]:[Customer PO], [Customer PO]2, [Value to be invoiced]:[Value to be invoiced]). I'm pretty sure it's correct, but the 'Customer PO" column uses a VLOOKUP formula which I think is what's causing aย #NO MATCH error...? Is there any way to get around this?ย
-
How to update a cell with a formula?
What would the syntax be in the formula portion of the update be? I'm confused because some of the formulas I work with have the double quote character in it. For example, I have this as apart of my request. "formula":"=IF([Manager]@row = "Tom Hank", "TM", IF([Manager]@row = "John Oliver", "JO", IF([Manager]@row = "Elvisโฆ
-
Count multiple criteria in a row
I have spent hours scrolling through all the great advice in the Community, and there is not a formula that is working for me. I need to count all the Semi-Annual Update, In Progress, and Waiting on County in a column. =COUNTIF([Status Report]:[Status Report], "Semi-Annual Update") works great to count all of theโฆ
-
Count If less than 50 rows
Can you do A COUNTIF formula with less than 50 rows or does Smartsheet default to 50? If I delete the formula in the blank rows I get an "invalid reference" error message.ย
-
#Unparseable Error When attempting to use IF function
Hello Everyone, I am trying to write an IF function to automatically change the value of a certain cell for certain conditions. For some reason I keep getting the #Unparseable error when I type out this formula. =IF((NETDAYS([Date Need By] 6, Today())) < 3, [At Risk], [In Progress]) I have attached a screenshot of theโฆ
-
max value by category
Hi I'm stuck on figuring this one out. I am trying to generate a sequential number("Sequence" column)ย by category ("Application"). I want the formula to calculate the max value of all the records in sequence where application = application in the new record (user would have selected this from a drop-down. this is what I amโฆ
-
COUNTIF formula for visual symbol
Hello, I am trying to measure against tasks based on whether they are completed, on hold, not started. I have a status column using visual symbol representation and am trying to determine the countif formula to accomplish this so that I can measure against and build out the widget in a dashboard view. Any help is greatlyโฆ
-
Formula Help
I am trying to create formula that subtracts to different dates in my data but instead of displaying the date of the result I want it to display "On Time" if less than or equal to zero and "Late" if greater than 0. I got the formula to display correctly but it is auto displaying in my columns where no data is entered.