-
Critical Path based on a release
I would like to see a critical path on a large project based on a release number. The critical path seems to be only available on a sheet basis. I can use a critical path filter that works great – but again works on a whole sheet. I was thinking about using a Release Number filter and then copying just those rows to a new…
-
Separate reply-to email address for auto emails
Hello, I'd like to vote for the feature of a separate reply-to email address when setting up auto emails. I'm the owner of a large number of sheets, and despite it not necessarily being a problem that emails appear to come from me, i'm having a huge issue with the large number of replies i receive. Despite adding text in…
-
Fix Errors Due To Managed References Within Collections
Sheets/reports within a Collection that have managed references to sources outside of the Collection will fail with errors for those formula cells. What's the point of Collections if you can't pull source data into it from outside the Collection in Workspaces you don't want people to have access to? I didn't have this…
-
Archive Project w/o Control Center
We do not own Control Center. What is the best practice for archiving projects?
-
Changing Seat Type to Guest
This new model is completely confusing and sneaky. I gave access to external folks as admins because that's still a choice you can make at the workspace or sheet level. Now they're listed as viewers in the admin center, so they can't actually do anything with the sheets I need them to be able to collaborate on. I read that…
-
Not Working - Send me a copy of my responses
The form allows to check the box: However, when checking the box the form remains inactive, no error message appears. Form does not complete. Only by unchecking the box will the form complete/submit. Please advise of fix. Thank you!
-
index match using multiple critieria
Hello, I want to use a formula using INDEX/ MATCH Function using multiple criteria to get a single value I am trying to get a value of Column Description from File 2 based on matching Source System ,Table name and Attribute Field Index ( as the column names may be different ) The formula Im using gets me an INVALID…
-
How to find an automation among many in a sheet
Hi, I have many (>50) automations on a sheet and I often find it difficult to find a particular automation given the paltry search and sorting functions within the Manage Automation Workflows. To recap, you can (only) filter by (All, Active, Inactive, Unable to run) or sort by (name, date created, date modified, last run).…
-
Integrating Different Smartsheet Project Schedules
I'd like to integrate some of the task information from two totally different smartsheet schedules into the primary/main project schedule but not all of the tasks in the two different schedules. Is there a way to integrate just some of the tasks from the different schedules and also have predecessor relationships to tasks…
-
How to bulk create cross sheet references using Python and Smartsheet API
Hello, This post provides a solution for quickly adding cross sheet references to a large number of sheets. The cross sheet reference refers to a single column. Caution The API code can update any sheet where you have permission to create cross sheet references. There is no way to automatically remove or edit cross sheet…