-
Formulas per column
Hello, Smartsheet team: If I select a cell containing a formula, I know I can drag the little box in the right-hand corner downwards to apply the formula to more cells of the column. Unfortunately, I need to do this for 300,000 rows! Is there a shortcut that will apply a formula to the entire column, or to a selected part…
-
Send an Update Request at a Specific Time on a Specific Day
I have read several post regarding the ability to control an update request / timing. I have tried this multiple ways. 1) Created a Form - I struggled with the team picking the correct date (this was necessary). I setup a Outlook Calendar Reminder weekly so it would remind them at a specific time. When they submitted the…
-
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…
