-
vlookup of image
Hi, Im Senando Benig Jr, Just Sen for short, Im in manila Philippines, My company start smartsheet from scratch and im the one assigned to develop an application. I explore smartsheet for more than 1 year and i think im in advance now. My concern is , is there anyway to vlookup and image? because when i try to vlookup it…
-
Need help with using a COUNTIFS with OR
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> Status [Open <or> In Progress] My Status column is using RYG balls, so "Red"=Open and "Yellow"=In Progress. I keep getting…
-
Form Submission
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 so, how do I do that? Can this be done automatically without me having to check daily and send notification via email…
-
Adding Formulas to Predecessors Column...Or Is there a Workaround?
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 now, I've been able to use the Predecessors column with ease, for e.g. 1FS + 5d, meaning that the project on the 2nd row will…
-
Highest value on the last six values of data
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,0,6,1)) but I see "offset" is not compatible with smartsheet. I don't believe Index and Match would work with what I'm…
-
Webinar: A 2020 View of IT PMO Trends, Best Practices, and Technology
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 Management at Smartsheet. Together they present how IT PMO leaders and practitioners are leveraging the latest in technology to…
-
There´s a way to copy a row to another sheet with a if formula?
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 a date on this column. Is this possible?
-
Row and Sum calculations for Capacity Management
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 spend on Projects, Operations, Enhancements, and Admin. There may be muliple project, operations, or enhancement rows. I'm…
-
Audit Compliance and Security Smartsheet
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 pre-audit checklist on page 5 and the project plan on page 6. Does anyone have a similar template to share? I'm starting…
-
Basic RAG Calculation formula based off completion % in project schedule
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 it's not scheduled to start yet, return Clear/Grey If past the scheduled finish date and % complete is less than 100%,…
