Hello, i need to share a specific folder with 5 sheets without sharing the whole workspace. Can't find anyhting on sharing folders and appreciate any help. Thanks!
Hi In order to intergrate another Application I would like to use the API to request a list of Smartsheet row ID's and selected columns (possibly just 1 column which the the primary key in the other application. This would either be all rows or selected rows. The best output would be as a CSV file eg: mySheetRowIDs.csv ID,…
Hi all, We're using Smartsheet sights for our weekly confcall on program progress in full screen "presentation mode", which is really doing great for us. One of the widgets in the sight is showing actual gantt charts per project and it gives us the right level of detail for the call. As the project list is growing rapidly,…
Hello, I am am struggling to get SUMIFS working with multiple criteria values. I want to sum data based on Month column and then by probability column. Here are a couple methods I have tried but I cannot seem to figure out what I need to do in order to make it work. =SUMIFS(Month:Month, "March", Probability:Probability,…
I frequently send sheets internally to request for updates through the "Email Shared Users" option. While I know there's a CC me option, I think it would be more efficient if I could find a log in the sheet of when users were emailed rather than digging through my own pool of emails.
Hi everyone, New to Smartsheet - very excited about the capabilities. Wondering if anyone out there is utilizing the system as a Work Order System? We get batch work orders from our hardware's proprietary dashboard system via email (excel). I would like to drop these into Smartsheet - using perhaps the help desk ticket…
Hello. I'm a new Smartsheet user. I used the "built-in" duration column to calculate the number of workdays between the Planned Start Date and Planned End Date. I also need to calculate the number of workdays between Actual Start Date and Actual End Date. What is the correct formula? (It would be great if Duration were a…
I currently use an external tool to conduct 200-300 surveys and collect data on project performance for my org annually. Data is exported from the tool and compiled in excel. I want to transition to SmartSheet to alleviate the manual survey creation and lift and shift of data. Problem: Each survey is customized listing a…
We use a sheet to keep track of documents in the review process. Is there a way to set a filtered alert so someone identified as a document reviewer gets notified when they have been added as a reviewer? Would also like to know ifthere is a way to filter an alert so that a user who uploaded a document for review only gets…
Hello- I am working on converting an inventory spreadsheet that is currently in excel and moving it over to Smartsheet for additional functionality. I would like to include images - is it possible to actually hyperlink an image once it is attached? Thank you!