-
How can I automate/manage the update of URLs included in my dashboards as I provision new projects?
I'm wondering if the URLs included in my dashboards will update with the correspondent new one so as I provision new projects. For example, I have a form URL included in the blueprint dashboard, This URL comes from a sheet also in the blueprint. The ideal scenario will be where everytime a provision a project from control…
-
Transfer Sheet Folders When Merging User Accounts via user management console
Hello Support, Currently sheet folders do not transfer to a new primary account when using the user merge function, please include sheet folders in the current user merge tool within the user management console.
-
Referring to a Cell in Another Sheet that Contains an Hyperlink
I am wanting to refer to a cell (or find a match in a range of cells) in Sheet 1. The cell in Sheet 1 contains a hyperlink. What I get in Sheet 2, however, is just the text in the cell, not the text as a hyperlink. Sheet 1 (contents of cell, text as hyperlink): BUS 123 6Wk Online What I get in Sheet 2:(text but no…
-
Copy the contents of a cell to another sheet only if a column in the same row is set to "Yes"
Hello, I am trying to automate copying of customer names from one sheet to another based on a second Yes/No column. Only customers with "Yes" in the secondary column will be copied to the new sheet. The secondary sheet will contain additional columns, so the Automation function will not facilitate the copy in the way I…
-
Segmenting within Grids
It would be really helpful if Smartsheets allowed segmenting to provide the ability for formatting by cell or segments. For example, have the top segment of a Smartsheet have columns with formatting by contact names, and the bottom segment be a list of values, associated with the contact names in the rows above. Format…
-
sheet with a form and history feedback
Hi I am Sascha and since January active user/admin of Smartsheet in our company. We have our portfolio and project management running and I think from time to time about some improvements especially in the project reporting field. we have these latest status section where the PMs shortly report current status in general -…
-
Assigned Person Changed in Automated Workflow
I created a round robin process that takes the next person on a list of people and automatically assigns a project to them when it is added to a project list. If that person is out of the office, I created an automated workflow where if a project was assigned to them to re-assign it to the next person on the list. The…
-
Changing Intakes for Projects already provisioned.
We are in the process of trying to change intakes as part of a movement to make our structure more scalable for bringing in new business units within our company into Smartsheet. Originally we had all of our projects being provisioned off of our ePMO Intake sheet. We have now developed a Master Intake sheet that will be…
-
Slot scheduling conflict within a date range
Hello Smartsheet Masters, I am making a scheduler sheet for equipment slots. The sheet contains these columns: Conflict (Checkbox), Row (Dropdown list), Slot (Dropdown list, multi-select enabled), Start Date, End Date. I would like the Conflict cell to be automatically flagged if any one or more slots have already been…
-
How do I amend this formula
What should this formula look like if I also want it to ignore any tasks that do not have an end date? =IF(AND([End Date]8 < TODAY(), NOT(Status8 = "Complete")), 1, 0) Its template formula from a project template set that surfaces at risk tasks to the roll up dashboard. IE those where the end date is i the past and the…
