-
Compare cells if not blank
Hello, I'm trying to compare two cells (both containing a city) to see if they match but I don't want blank cells included. Thank you for any help. I'm sure it's easy, but I've already spent waaaay to much time trying to figure it out! ๐
-
Project Planning: Percentage Complete from Dates
Hello I'm currently using Smartsheet for project planning. I want a forecasted percentage complete on progress to date from baseline start to baseline finish. Can anyone help please? Thanks in advance! :)
-
Summary Formula
Hello, I am using Smartsheet for project planning. I would like to track adherence to plan, specifically counting the average of the Start to Plan and Finish to Plan and represent the number separately as a percentage so I can see what percentage we start and finish to plan when it happens. I have created an Ancestorsโฆ
-
COUNTIFS and OR criteria
Hello, I am trying to create a formula to pull from two different columns where one has multiple "or" scenarios. For example, I need a count of rows that = "Not Started" and is either = "BD, Bid Mgmt, CRO, Customer, Product, Sales, or Other". Below is what I've been trying and it's not working. Appreciate the help!โฆ
-
Formula to find the average word used in a column
Hi, Is there a formula I can use to find the average "word" used in a column? For example, I want to find the average of these words from the drop-down list: Cheers! Ann
-
Count how many tickets have been completed before the due date
Hi, I'm trying to create a formula metric to count the number of instances that a ticket has been resolved before the due date has expired. I'm a bit lost how to use =COUNT(IF([Due Date]>[Resolved],1,"")). Sorry new to smartsheet appreciate any help. Thanks
-
Index Match Contains?
In Sheet 1, I have a cell with something like this CAP-400-BL, and I want to search another sheet for an instance of this (there would 0 or 1 instance), but then I want to send back value in a different column in that other sheet. SHEET 1 CAP-400-BL | 202160 <-- This is pulled from Sheet 2, based on CAP-400-BL๏ปฟ ๏ปฟ SHEET 2โฆ
-
Formula to include weekends & Holidays in count but exclude weekends as a date for the result
I'm converting a file from Excel to Smartsheets for Quarterly, Semi-Annual, & Annual inspections. I want to set the first inspection date up and then have formulas in place to auto assign the remaining inspection dates for the next 2-3 years. I'm using WORKDAYS with an if formula which is providing a result but it's notโฆ
-
Formula to show top performers with column title
I have created a metric sheet to show how many hours an employee spends training, per period, for management but would also like to show the top 3 performs, per period, as well. I know how to use the LARGE function to show the top 3 numbers but don't know how I can have them show what employee it is pulling the informationโฆ
-
Average Formula Question - scoring
I am adding up scorecards and averaging sections, then coming up with a GC Total Average Score. Sometimes there are no score (blank). I would like those blanks to be changed to N/A and not calculate in the average score. Here is a screenshot of the several different average columns I am working on. I would like aโฆ