-
Return Red Amber Green
Hi All, I wish to return a single rag status from two columns. The two Columns will display "Yes" or No individually. If both columns are "Yes" I wish to return Green If one column is "Yes" and the other "No (or vice versa) I wish to return Amber If both columns are "No" I wish to return Red I am not sure which function I…
-
Separate numerical and text values of differing lengths from a single cell into separate columns
How do I separate numerical and text values of differing lengths from a single cell into separate columns? For example, I'm trying to total the "AREA" Column, but due to having "SF" in the cell, it will not return a numerical value. The numerical values to the left are of differing lengths, making this problematic. The…
-
Multiple IF functions
Hello, I would like to Nest two If functions in one cell. Below is what I have, but I am receiving an error #unparseable. =IF([ENM INITIATED]@row = 0; "Red"; "Yellow", IF([JOB STATUS]@row = "COMPLETED"; "Green")) I would greatly appreciate your help. Thank you
-
Copy Contacts
This discussion was created from comments split from: Copying contact information from one sheet to another.
-
Can you copy cells in a workflow without their children (subtasks)?
I created a workflow to copy certain rows into a new sheet when a value in that row is met. The issue I'm having is that I just want to copy any row (parent or child) that meets that criteria - if it is just the parent task, i don't want all the children to be copied as well. Is there a way to do this?
-
Need help with Sum by month
I am working on creating a summary sheet to show totals by the monthly forecast. Not sure how to connect the data correctly to this sheet. Source smartsheet Thanks in advance
-
"Date" cell updates "status" cell
Hello Community! I have been searching thru the posts for a solution without success, time to ask you all wonderful peeps! I have a tracker to manage damaged items, one of the steps is to assign the job to an external designer contractor, the contractor enters an Estimated Design Completion Date and once the design package…
-
Cleansing URLs
Hi Smartsheet Community, I'm trying to streamline URLs that are being submitted to my team. =IF( ISNUMBER(FIND("https://www.", [Original url]@row)), SUBSTITUTE([Original url]@row, "https://www.", "") , IF(ISNUMBER(FIND("https://", [Original url]@row)), SUBSTITUTE([Original url]@row, "https://", "") ,…
-
#UNPARSEABLE When Creating =AVERAGE(COLLECT Formula
I am trying to pull an average of months employed for current employees in a specific division. My formula is: =AVERAGE(COLLECT({MonthsEmp}, {TermYear}, "CURRENTLY EMPLOYED", {DivAtTerm}, "ADMIN")) {MonthsEmp} is a column formula: =ROUND((IF(ISDATE([Term Date]@row), IF(NETDAYS([Term Date]@row, TODAY()) > 0, NETDAYS([Hire…
-
Solving for data issue when exporting data from external source.
I am trying to create a helper column that will help a colleague manage data that he needs to export from our inventory management system to evaluate in a team meeting. The issue is that he has currently been manually fixing a common data error where, occasionally, the name of an item is exported incorrectly. It always…