-
SmartSheet connectivity via ODBC
G'day We are looking at the possibility to migrate our project meeting minutes from Excel to SmartSheet. The Excel-based minutes have columns that pull data from different sources, being Sage and Dovico via ODBC (extracted data is in another tab within the Excel file), is the same possible in SmartSheet? If so, would…
-
Easily merging multiple sheets into one comprehensive sheet
This may be a very specific problem but I appreciate any help! I am collecting a certain set of data from people and what I would like to do is provide an Excel template for folks and once they return the template, upload their data into Smartsheet. I know that any import creates a brand new sheet. But I'd like all of the…
-
Report sort order
I have a report, linked to a sheet that I'm struggling with the report sorting. Within the sheet, I have rows numbered by a category type, and sorted within each category. The corresponding report is not reflecting the same sort at the sheet. I have re-loaded the sheet, refreshed, signed-off/on and still no luck getting…
-
Report vs workspace permissions
Hi all, can someone please verify whether the workspace-level permissions override the sheet or report-level permissions? For example, I have a user I'd like to have Viewer permission on the overall workspace but Editor permission on a specific report. He has Editor permission on the underlying source sheet (located…
-
Problem email
Hi, I have a problem with my smart, it does not allow me to send mail, it tells me to exceed the maximum amount of email that I can send from my account, to put me in touch, help me see if there is an option to delete emails or something not to increase the amount of mail
-
Resource Management Groups
As a Project Manager I need to assign "Non Human" resources to tasks within my Smartsheet project workflow. Some of my project tasks involve using multiple computers for processing. Depending on the size of the project, it can be anywhere from 15 to 100+ computers being allocated to that task for processing. My company…
-
Multiple Contacts Update Request
Hello! I have a column allowing multiple contacts. I also have a update request set up to update the users (plural) in the cell when something changes. My questions: 1) Does the update request go to all users? 2) If yes, can the information updated be overridden? For example, if the first user updates something in the row…
-
Sort, Second Sort, Third Sort (then by, then by)
Trying to sort, then by, then by. Anybody find a work around, second and third sorts pushing tasks to the very bottom of first sort. When the first sort has exhausted all available data I would like items that meet second sort criteria to start in, not be pushed to the very end first sort.
-
Rolling up end dates to parent rows, excluding completed items
I'm having trouble getting my sheet to roll due dates for projects up to parent rows without excluding projects that have already been completed. I've tried enabling dependencies and using a min formula that looks at children rows, but neither options worked. I have no need to track start dates on this particular sheet,…
-
Sending attachments
Hi, I send attachments from Smartsheet and my recipients received it in their 'spam folder'. How can we troubleshoot this issue? Thanks!