-
Loss of Function - Select/open multiple
We were able to browse any workspace or folder of favorites and select multiple sheets from them. then open them all at once - but this feature is now gone. Checked the text of the announcement. It says that in order to do the thing that was already working in Smartsheet, you have to use some other system built into the…
-
Sumifs cross reference multiple criteria
Hello, I have a sheet where I am trying to reference multiple criteria from another sheet. For example I am looking for a count of Patient Fall with Injuries from a specific site. My formula is coming up as an incorrect argument. Any ideas on what I am doing wrong? =SUMIFS({AOD Master Patient Care Events template Range 3},…
-
Extracting all instances of a word from a text string and creating a list in a separate cell
Hello all, I have been pouring through excel and smartsheet help forums for a couple of days now, and I haven't seen my issue asked or addressed so thought I'd ask here. I have, in one column called Terms, cells that contains lists of terms and phrases. For example, one cell contains the following text string:…
-
Formula help - trying to sum a column if launch date is in the next 30 days
Hello, I'm trying to sum numbers in a column a if the launch date is within the next 30 days. Thanks in advance for any help!
-
Cannot parse the Hyperlink function, unfriendly hyperlink import
OK, so the only way I have found to import a hyperlink is to do a lengthy workaround. When creating spreadsheets with lots of hyperlinks based off of a reference number, I use the hyperlink function to generate the links to URL by putting in the =HYPERLINK(domain,number) formula. This is way better than manually generating…
-
Auto-populating formula when pasting multiple rows
Is there a way to populate formula in columns if multiple rows of data when pasting several rows to the columns next to formula column? I would be willing to use CTRL +D, but it does not work in either of three browsers I have.
-
21 CFR Part 11 compliance and software validation usage in Design Control
I would like to request if there are MED device users to share their experience while working on medical device or pharma projects that are related to new product initiative filings requiring regulatory complaince in closed loop systems integration and security. Have you had to prove part 11 and validation compliance? Your…
-
IT Portfolio Rollup
Hi Community, There have been numerous posts about how to essentially rollup multiple smartsheet projects into a portfolio/dashboard to show overall status information about the portfolio. I get the essence of the various posts, but before going down those paths to figure-out how to build something from scratch, I'm…
-
Vlookup
Hello, i have a sheet with billed claims including a column "Pending Amount", and "Detail ID", each line item has a different detail ID, now i want to update the pending amount column according to another sheet, i tried the simple Linking Cell method but it did not imported the pending amounts to the right detail ID's. and…
-
Score Formula
I've created a scorecard in smartsheet and want to create a formula that does not allow the scorecard score to show as more than 100%. I think is should be something like If score >100%,100% but am not sure what the entire formula should be.