-
How do I find a smartsheet expert for hire to help build out our workspace?
I am building out a new workspace for some large marketing intergration projects. I am way over my head with smartsheets, but I have used it to complete amazing M&A sheets. I want to start intetegrating smartsheets into the operating side instead of just the due diligience side of the business.
-
Generate list of recently updated sheets
I would like to have a quick readout of the five or ten most recently updated sheets from WorkspaceA or WorkspaceA --> Folder5 I can build a report that grabs all of the sheet rows by updated in the last 30 or 60 or 3000 days, but how can you get a list like: * FinanceSheetXYZ updated Yesterday by John Smith *…
-
The "New Smartsheet Navigation Experience" is Great! TY!
The New Smartsheet Navigation Experience is GREAT! The #1 feature I'm excited about is Browser Tabs and Direct Links. Being able to copy the URL straight from the browser. I spent a LOT of time as a champion and mentor explaining how to get the URL to share a specific sheet. I really believe this will enhance the new user…
-
Status Change if Column Checked
Hi everyone, I need some help with a formula that just doesn't want to work for me. Currently my status column changes according to the {Proof Approval - Kim} column. It works fine (formula shown below) Now I want to add on to this formula so, if the column {Out For Approval} is checked, I want the status to change from…
-
Help with SUMIFS & INDEX/MATCH Formulas
I need to first find the column number where the number 1 resides on the "Lookup Value -->" row. Next, I need to shift two columns to the right, which would be "4/2019 C" and sum the values for Client B, I have tried various combinations of SUMIFS, INDEX(MATCH()), etc.,but with my last attempt, I received #INVALID VALUE…
-
Auto Number Formatting
Hello everyone:) I currently have a sheet populated via a web form. There are several people assigned to tasks. My goal is to have an auto number column to populate a prefix & suffix, based off the person assigned & their corresponding ticket number. I don't know if this is even possible. Lets say I'm assigned a task, the…
-
Problem with search bar
I type text in search bar, but the search function doesn't pull the information, even though its in a sheet. I have cleared any/all filters. Not sure why it won't pull the information. It's clearly in the sheets. I screenshot information in one of the sheets in question. I also showed the search results not pulling the…
-
Salesforce ServiceCloud Users/Connections
Hi Smartsheet Community, We're thinking of some use cases for helping Smartsheet users utilize Salesforce ServiceCloud data more effectively and efficiently. Any Salesforce ServiceCloud users out there who would be willing to chat with us and give us feedback on our use cases? Even if you don't use ServiceCloud but know…
-
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…
-
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:…
