-
Has anyone turned into the Employee Onboarding template into a rollup format?
Hi all, I'm working on a project for Employee Onboarding. After discussing with stakeholders, I think the Employee Onboarding template (Setup: New Employee Onboarding - Smartsheet.com) is a great start, however it doesn't meet some of the needs we are looking to cover. I'm reaching out to the community to see if anyone has…
-
Double Dependency
If I have a task that starts when one task finishes, but needs to finish at the same time as another. Is that possible in Smartsheets? when I include a SF with one Task, and FF with another it calculates a (1) day value and finishes with the task associated with FF
-
How to add columns based on user input from another column?
I have a field called Number of Children in my form. The user then inputs the number of children they have. What I am looking to do is have other fields added based on what the user input for the Number of Children field. For example, if the user inputs 4 in the Number of Children field, I want a Name, Age, and Gender…
-
Transferring Ownership of Multiple Sheets/Reports/Dashboards at once
Hello, I've got a scenario where I helped a user (let's call him User 1) create a process, however, he (User 1) has switched positions and it is time to reassign ownership of things to another individual (User 2). Between me and the original user (User 1), we created all the sheets, reports, and dashboards in the…
-
Dashboard not updating after Sheet changes
For a number of years, our team has been reliant on a PDF Dashboard to issue to our clients. Recently, we have noticed that after new data is input into a Sheet, the Dashboard no longer reflects these changes automatically. Our system is programmed to work in the following manner. (A three-step process -…
-
Managing Multiple Weekly Update Requests
Hi - Wondering if anyone here can help. Our IT organization has a master source sheet tracking all the project requests for the team. Requests are made through a Smartsheet form which inserts a row on the master source sheet. As part of the development request, the PMO send out weekly automated update request to each of…
-
Date stamping the latest comment?
Is it possible to include the date with each comment in the Latest Comment column?
-
Import from .mpp file not perfect?
Recently have been testing out functionality within Smartsheet to compare to other products that are very similar and there seems to be a critical issue with the import functionality from MS Project .mpp files. See below from the same .mpp file: PCH-36 should be a parent on the same level as ASC/OQR, the section is…
-
Index Collect value based on a date
I want to index a value if the "This Sheet Date" on my final result sheet is greater than "Date Value Effective" on my database sheet. Screenshots should help. I have a column showing the value that I want it to return. It's showing me the 2% because technically all of the "This Sheet Dates" are greater than the "Date…
-
Discrepancy in API document and response for Sheet Object
I noticed in the Sheet Object API document, https://smartsheet.redoc.ly/tag/sheetsObjects#section/Sheet-Object, the field is "proofs" object, while in the API response for the same for "Get Sheet" API, the field is a "proof" object. There is a difference in singular and plurality, Is this a discrepancy? Can you please help…
