-
formula for raid log
I would like a formula that if a user selects risk in the type column and enters the risk information.. and later on in the project this risk becomes an issue.. the formula will auto score the likelihood column to default to 5. Can anyone help with this please?
-
How to find an automation among many in a sheet
Hi, I have many (>50) automations on a sheet and I often find it difficult to find a particular automation given the paltry search and sorting functions within the Manage Automation Workflows. To recap, you can (only) filter by (All, Active, Inactive, Unable to run) or sort by (name, date created, date modified, last run).…
-
Changes over Time - COUNTIFS?
I have a project where a group of users can submit a smartsheet form at any time to request a new enhancement to one or more of 3 tools. One of these tools is managed by an outside vendor and therefore management wants to be able to track number of enhancements submitted to them as well as how they progress through status…
-
Control Centre push an update to all provisioned worksheets
I have a large number of assets that have been provisioned through Control Center. I want to install a formula in one cell in a specific column. I thought I could update the template in the source folder of the blueprint and publish it, however, that functionality has been removed or I can't quite figure out how to do it.…
-
Does anyone have a project plan used to bring Smartsheet into your company?
Looking for a project plan that I could use to bring Smartsheet into my company. We are going to be needing SSO Control Center Building Templates for Control Center Building out connectors (mainly for Azure DevOps) Creating Reports (for projects but also for users to see open tasks by project assigned to them) anything…
-
Collecting info via forms, but cells are getting too full: What's the best solution?
Hi all, Here's a quick description of my set-up. We're collecting project progress updates via workflow automations. These forms get sent to various people and the main 'ask' is for them to fill in a free text entry called 'latest update' field. These entries then appear in the 'latest update' field on the main sheet. This…
-
Attachments to In-Cell Images
I cannot figure out how to automate the process of moving cells to images. I've read this can be done through power-automate, but frankly coding is out of my expertise. Is there a simpler way to do this? These attachments are added through form entries.
-
Too many years showing
How do I limit the number of years displayed on my Gantt chart? Right now it is defaulting to showing both this fiscal year and next. Isn't there a way to limit the display to JUST this fiscal year? Thanks.
-
Multiple Forms - Add info to existing row
Hello! We work with a registration form that feeds a master sheet, we want to add another form that will update or add a request for change for a registered contact, but we do not want to generate a new row, we want Smartsheet to match the name or ID to the initial registration and update the columns. Do we need a formula…
-
Custom Colors for Sheets
While it is wonderful that we now have the ability for custom colors on Dashboards, it would be truly helpful to also have this same ability in Sheets. It would be really helpful for some of our projects because our district uses certain colors to call attention to various district initiatives or our district instructional…