-
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.
-
Keeping cell with a formula even if its blank...
Hello... I've taken over SmartSheet from my predecessor in my workplace. I have over 30 different process steps in the Due Date column that work off the actual date for a writer's task process. The two columns of information are Due Date (1st Column) and Actual Date (2nd Column). How do I keep the formulas in the (30)…
-
Hyperlink
Is there a way to include a hyperlink in an update request when they open the update form button?
