-
Use the internal row id
We manually add the internal rowID to a new row by selecting the row properties, copying and pasting it into a field. Then a URL is calculated to provide a link to that specific row. It would be helpful if there would be a way we could generate a hyperlink but access the rowID directly something like:…
-
How to calculate days a ticket is open/closed
I am trying to calculate how many days a ticket remains open but I also need that formula to stop counting if the "Ticket Closed Date" column is filled in. I have tried a couple but they keep coming back as errors. There are multiple selections for the Status of Ticket column... Work Has Not Started, Work Has Begun,…
-
Can't Create a Single Grid Sheet anymore? Why did this change?
I am unable to easily create a grid sheet unless I do it through the Workspace panel. I used to be able to right-click anywhere in my sheets folder, for example, and add one, or hit the create button, which offered options. Now, the create option directs me to the same location as the left navigation, and there are so many…
-
How do I set SmartSheet to include attachments on the emails that it sends from automation?
Has anyone had success in having SmartSheet include attachments on the emails that it sends from workflow you set up? When I create a workflow in SmartSheet to send an alert to someone I want to have the email the user gets include an attachment. Currently my trigger for the workflow is when the data in a certain field…
-
Keep "Sheet Reference Manager" open after creating a new reference: create multiple references
I often setup all of the cross sheet references from the Sheet Reference Manager before addressing any formulas. Currently, the reference manager closes after adding a new reference. If I am adding several references, this means right clicking on the sheet and selecting the reference manager again before creating each…
-
Row Change Notification Being Triggered by Rows Added Through Form
Hi there I've setup a notification that's triggered by a row change. However when a new submission is made via the form (i.e. a new row is added via the form) it's triggering the notification as well. The notification is: "Trigger: When rows are changed AND when column1 changes to any value, or when column2 changes to any…
-
Cell-linking from another sheet in the Predecessor column
Please enable the ability to use the cell-linking from another sheet in the Predecessor column. Importing dates from another sheet in a new row and then using them as a predecessor can disrupt the duration and critical path of the project. Thank you.
-
Critical Path using a Start-to-Finish predecessor
This is a scenario for projects where the finish date of the last task is dependent on the start date of a task/milestone (most likely from another project). For example, if the project is to decommission an application then disabling the application (last task) cannot occur until the new application goes live (start date…
-
How to get the count of unique values from a list of repeated unique values
I have a list of people lets say Jon Sam Rick each on of them is assigned to a colour lets say any combination of colours for something that looks something like this ( see screenshot). How can I count the number individual colours for each person. For example Jon has a combination of 5 red and 5 green so his count should…
-
Cross-sheet predecessor without using cross-sheet reference
In sheet 1 there is a date 1 which is a predecessor (SF type) for last task in sheet 2, so that date 1 is later than any task in sheet 2. When I use a cross-sheet reference to import the date 1 into sheet 2 and then simply use it as a SF predecessor, it does two things that I need to avoid: it erases the critical path for…