Hi, I'm trying to create a nested formula used in a ticketing system that will total up active status (Open or In Progress) compared to location. Ticket Active Status for Location = Location <and> Sta…
If I create a form in smartsheet and someone were to complete the form, can I make it so that multiple people can be notified about the form submission and have access to the information submitted? If…
Hi there, Okay, so here's what I'm trying to do. Our team is using a smartsheet schedule and within that schedule, is a bunch of sub-schedules, that all work together in glorious harmony :) Up until n…
I'm looking to find a formula that will capture the last six months of data and then return the highest value within those six values. On excel, I've used, for example, MAX(OFFSET(B3,COUNTA(B3:B113)-6…
In this webinar, you'll hear from Andy Jordan, President at Roffensian Consulting, Greg Alexander, Director of Project Management at Citrix, and Rajiv Arunkundram, Senior Director of Product Managemen…
Hi everyone, i have a group of four sheets and i want to copy specific rows to another sheet. I have a column called "FORMAL RECLAMACIÓN" and i want to copy the entire row to another sheet if there´s …
So, until we get 10k feet, I am trying to figure out how much of our team's capacity is spent on projects or operations work. In the sample below, I'd like to know how much time teams and sub teams sp…
I'm looking for the smartsheet template that was shown in the Audit, Compliance & Security Solution Guide. The guide links to a site that no longer works - I was hoping to locate the template for the …
Hello All, I would like to know if anyone knows how to set up a basic RAG formula based on completion % and the schedule date. Custom criteria would be as follows: If % Complete = 100, return Blue If …
Hi there, I have multiple change projects to track within the general IT PMO along with other non-change projects. My goal is to consolidate them and list them underneath the 'change' category and so …