-
Internal Smartsheet Links
I have a sheet that lists all my my projects and one of my columns on that sheet is for hyperlinks to other internal smartsheets. These are sheets associated with each row's specific project. I would like the option to right click on those hyperlinks & "Open in New Tab".
-
How to automatically include project names in automated update requests and forms
Hi, I have several projects that follow the same breakdown structure, when Smartsheet sends automated update requests, users are receiving these notifications don't know which specific project the request is referring to. I noticed that the project name is not an automatically included in all update requests for different…
-
Global update - cross sheet formula needed
Hi All, While doing a global update I added new column ( type: Contact) I need to change the formula to that column. The issue is the formula is cross sheet =IF({Project Metadata (Do Not Edit) Range 3} <> "", {Project Metadata (Do Not Edit) Range 3}) it is meant to pull a an email address into the column from a different…
-
Merged: SCC Global Update for adding a new row with "task information" to a Project Plan
This discussion has been merged.
-
Seeking Advice on Rolling Out a New PPM Blueprint in Smartsheet
-
Adding Cell Links to Existing Profile Data
For a period of time, 2 profile data fields were incorrectly set to One Time Write, rather than Cell Link. I need to correct this and add the Cell Link behavior for these 2 fields from the intake sheet to metadata sheets. I have tried the Add Profile Data trick to apply a pseudo Update Reporting Global Update, however that…
-
Include additional advanced formatting options in Global Updates
Per this help article, the following aren't available to configure when making column-related Global Updates using Control Center: Currency Percentage Thousands separator Decimal places Date format This makes the implementation feel half finished, as you still have to go into each sheet and make adjustments. These should…
-
Multi-Select Projects to "Update Reporting" in Control Center
Whenever a change is made to a blueprint in control center we are already disadvantaged by only being able to apply this change to future projects created from the blueprint. We can however, using Global Updates retroactively add certain rows to summary sheets that can be a proxy to apply changes to existing projects.…
-
Control Center Global Update Text vs Numeric
I'm working in Control Center on a Global update to change a field from "N/A" to 0 (aka zero). When testing the update I noticed that it changes to the text of "0" as it's left aligned vs right aligned. Any ideas how to update from a Text to Numeric via Global Updates? I've tried different variations to force numeric:…
-
Control Centre Global Update
Currently, when using the sheet global update option for inserting a column, we are restricted to using a single date format. It would be helpful if we could use options for the modified date as well.