-
"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://", "") ,…
-
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…
-
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…
-
Mean Time Between Two Dates from Form Submission
Hi Community, I'm attempting to find the average downtime of an asset between dates from a form submission for the month. For example below, I need to find the number of days between the "OOS Tag Removal Date" and "Date OOS Tag Applied", based only on all entries for "Asset ID" FD-001201 where the "Reason for OOS" is…
-
Reference Error
Hello, I'm attempting to create formula that references a specific month but for some reason its showing as January 2022 Range 1, when every other column is correctly showing as February 2022 and its providing inaccurate information. Has anyone run into this before and have a fix? Thanks
-
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…
-
Averaging numbers once they have been filtered.
Good morning all, I am working on a report for multiple locations. I'm currently stuck trying to figure out how to create an average for counts collected between two dates. (Weekly/Monthly) I've created a filter that will allow me to select the dates I want to look at, but my total averages do not change when I filter my…
-
Countdown to future date not updating when sheet isn't opened
Hi All, I'm using the following formula to add a date countdown metric to a portal. =DATE(2022, 12, 1) - TODAY() The issue I'm having is that it's not updating unless the metrics sheets that I have the formula in is opened. Does anyone have a work around for this? Many thanks, BW
-
Why isn't there a function to return the row number?
We have [column]@row. Why not =ROW()? I really need a column formula that returns the row number.