Hello Smart People - I'm parsing a string using helper columns. I want to return all text to the right of my last "-". For example, QA-IS-OPS would return OPS, and QA-ARC-RM would return RM. Is there …
Hello Smart People - I’m building a simple asset management solution. I want to track assets as they move between locations using barcode scans only. I have a “live” sheet that has the current locatio…
Hello - I'm using INDEX to find the value of [Scanned Location] that corresponds to the MAX [ROW#] of a collection that matches my current [Asset ID]. My formula is =INDEX([Scanned Location]:[Scanned …
Hello Smart People - Simple question. I would like to keep a running tally of the time between dates in the same column as it progresses via rows, so [Date]@row - [Date]@PreviousRow. Make sense? I thi…
Hello Smart People! I need to report on some data that I have compiled from many sheets in a Smartsheet report. The reporting tool that we have is Power BI, but the connector to Smartsheet defaults to…
Hello - I have a column named "Monthly Hours" that lists hours (integers). I have another column called "Site of request" that lists the site(s). That column is multi-select. I would like to summarize…
