-
Reference Comment in Formulas
Please add functionality to address comments via formula, such as =countif([Comments]@row, "No Change") to simply count how often in a row a project is listed as "No Change" or how often something is commented on with =count([Comments]@row). This would add functionality for tracking KPIs and Leading Indicators which is…
-
How do I best link a list of entries in one column to an entry in another column?
What I'm looking for is the ability to create a list column called "Product" and have another column called "Options" which would have another list of entries filtered based on the selection in the "Product" column. Any help would be greatly appreciated.
-
Sum of Children not working
I have 1 Sum of Children formula not working and can't figure out why it isn't working. Here are some screenshots. What am I missing. It keeps giving me $0 where the formula is and should be giving 182.16
-
Cross Sheet Reference COUNTIFS
Hi there, I'm fairly new to Smartsheets so I apologize if there's an obvious answer to this question, but here's my situation. I have a sheet that tracks projects and their status. Along with the status column, there's another column that auto-populates the date a project is marked as "Completed". I want to create a metric…
-
Formula won't recognize values as numbers
Hi there! Problem = I have four "Text/Number" columns that I want to average Complexity = the column values are derived from formulas Issue = when I try to average all four columns with =AVG([Stakeholder Score]@row:[Complexity Score]@row) formula, it keeps throwing an error. Even when I try the long way around…
-
Referring to a Cell in Another Sheet that Contains an Hyperlink
I am wanting to refer to a cell (or find a match in a range of cells) in Sheet 1. The cell in Sheet 1 contains a hyperlink. What I get in Sheet 2, however, is just the text in the cell, not the text as a hyperlink. Sheet 1 (contents of cell, text as hyperlink): BUS 123 6Wk Online What I get in Sheet 2:(text but no…
-
Formula Error
I am trying to highlight and mark duplicate records with the newest Created Date, but I am getting this error... #Incorrect Argument for this formula... =IF(COUNTIFS([Order/Work Order ID]:[Order/Work Order ID], [Order/Work Order ID]:[Order/Work Order ID], [Order/Work Order ID]@row, [Created Date]:[Created Date], @cell <…
-
Sheets with cumulative values
Sheets with cumulative values We want a low-maintenance sheet that Uses column formulas Accepts new rows via forms Contains a running total in each row (e.g. budget minus spend) This would allow each row to show the diminishing budget — a burndown report. We found this answer by Leibel S. that is letting us create column…
-
Index/Collect - #incorrect argument set
Hi Can anyone please tell me what is wrong with my syntax? I have done index/collect before and the syntax is the same. The dates are "text" which shouldn't matter. I also tried numbers in place of dates and still get the same. I am baffled....
-
Copy the contents of a cell to another sheet only if a column in the same row is set to "Yes"
Hello, I am trying to automate copying of customer names from one sheet to another based on a second Yes/No column. Only customers with "Yes" in the secondary column will be copied to the new sheet. The secondary sheet will contain additional columns, so the Automation function will not facilitate the copy in the way I…