-
Export to Microsoft Project Aplying Filters
Hi All, I have been trying to set up a report and later on export to Microsoft project, although without too much sucess. The idea is to show only parents rows (project deliverables). The report is for a client which cannot see the full project plan. Smartsheet seems to always export the full project plan even when filters…
-
%Complete to be automated
I am trying to work on my sheet to get the % Completed to be automated. How can I go about doing this?
-
Allocation in Template Sets
Good morning. I joined the webinar yesterday regarding Template Sets and we've already begun creating a sheet for our projects using one of these template sets. Great job Smartsheet!!! We love the compatibility you have created with Project and this will definitely benefit us in the very near future. I did notice, however,…
-
cross-sheet duplicate search
Thanks in advance for reading this :) I have multiple inventory sheets, each has a column with a formula to flag duplicates within a specific column: =IF(ISBLANK([Serial Number]1), "blank", IF(COUNTIF([Serial Number]:[Serial Number], [Serial Number]1) > 1, "yes", "no")) Form there, I apply some simple conditional…
-
Update Request - Default Columns
Hello Folks, I love using the Update Request feature, but I do not enjoy having to manually edit/remove some of the columns that are included in the request. Is there a way to set default columns to be included in the UR so that I don't have to edit every request prior to my sending it? Thanks. Regards, Frank
-
Impact with Urgency equals Priority
Hi, I am looking into utilizing a ITIL related priority matrix approach to populate a Priority. The Priority levels column's cell would have values P1, P2, P3, P4, P5. The formula needed in the Priority column would output an appropriate priority level based on specified combination of values from two other columns: Impact…
-
Advice for creating Summary Sheet/Report/Sight
I have become fairly comfortable with Smartsheet, but need a solution that I could use some help on. I have Project sheets and reports for teams and users that use the Status field for counts. I want to create a sheet/report/sight that shows the status for all projects assigned to a team and each user. Hopefully this image…
-
Highlight Colours
Hello, I have an 'Alerts & Actions' when a row is added to email out many cells. When this email arrives in my staffs inbox the cells are bright yellow. Is there a way to change the colour? - I would ideally like a less bright colour? Any help would be wonderful. Thanks Matt
-
alert when someone fills out form
Hello, Is it possible to get an alert when people fill out a form? Thank you, Debbie
-
Hyperlink in a Request Update form
I am looking to see how I can insert a Hyperlink into a Request Update Notification.