-
Summary Field that Averages Field Entries that are Less than Zero
I have a calculated field for the time over or under a deadline date. I want to create a summary field that summarizes the number of days overdue for projects completed after their deadlines. Right now I'm trying =averageif([field name]:[field name],<0,[field name]:[field name]) I get an "Invalid Operation" error when I do…
-
Column Formula + Reports
Curious why a column that has a formula applied cant be changed when it's pulled into a report - from the report? Also wondering if there is a way that is quick to remove the formula from an entire column? I've switched one back to 'cell formula' to allow for edit from the report but, would like to avoid running down 600…
-
Question on Function Syntax using IF, AND, and OR
I am trying to get an At Risk check box to return a red flag if there is a date in End Date and that date is earlier than the curent date and the Status cell shows one of three statuses. Can't quite get the formula logic. Any suggestions would be wonderful. Thanks! Desired results: End Date is blank = no flag End Date is…
-
Nested If Contains Function Returning #No Match
Having and issue with a nested =IF(CONTAINS( function returning a result of #NO MATCH. Formulas work independently of each other just not nested. I also confirmed the "search value" within the VLOOKUP is on the lookup table. What am I missing? =IF(CONTAINS("ABC", [DC Location]:[DC Location]), VLOOKUP([Lane Concat w/…
-
IF/AND/OR Statements Help To Check A Box When Criteria Met
Hi, I am trying to write a formula with multiple IF statements with OR and AND to check the appropriate box: I have this so far and get #INCORRECT ARGUMENT: =IF(AND(NOT(ISBLANK([Term Date]@row))), OR(Program@row = "ABC", [Shared Programs]@row, OR(@cell = "ABC / XYZ", @cell = "XYZ / ABC")), 1, 0) Thanks for any help…
-
Issue combining data of 2 fields
I need to combine data of two fields. 1 field is a dropdown and the other open text. The first option to combine them didn't work: =TEXT([Content Subset]@row, "General") & [Playlist Brand]@row The second option was to convert the 'Content Subset' to text and then combine, but that again didn't work: =TEXT([Content…
-
COUNTIF based on a Sheet Summary Cell w/Formula?
Hello! I am trying to create rolling metrics of how many entries we have in the current Fiscal Year, Quarter, and past Fiscal Year. How would I reference a Sheet Summary cell's value? For ex, I want Total Orders of Fiscal Year to show me everything in FY23. My Total Orders of Fiscal Year cell has the formula-…
-
My Date Helper Row is Showing the Wrong Centure 1923 Instead of 2023
Hi All, I created a sheet where my users will select from a dropdown of available dates. This column is set to Drop-Down so they only can select the dates I offer. (Column Name = Selected Date) I have a helper column that is set to "Date" and has a formula to turn the text data into a Smartsheet date. (Column Name = Date…
-
Apply formula to full column
As lines are constantly added in a workinglist, I want to ensure any new lines will always have a column with a formula filled in. The formula will check certain data in fields on that line to show a specific status/value. I read that i should be able to 'insert' a formula on a full column, but can't find it. I'm only able…
-
Excel Text Formula
Hi, I am trying to use an Excel formula to extract the full month from the date. I am using the excel formula: text([Due Date]@row,"mmmm") and I am getting an error. Is there a similar smartsheet formula ? Thank you !
