-
How to count cells with BLANK value in a column
Say that I want to count how many cells with BLANK in a column? The column have many NOT BLANK values also. eg. ([Col]2 with BLANK value) Col row_1 a row_2 row_3 a .... row_n a so the column has 1 cell with BLANK, the count will be 1. How to write a formula to get the count? Thanks!
-
Count if & Unique Values?
Hi! I am struggling to figure out the logic required to count the number of monthly/quarterly/bi-annual/annual items without counting duplicates. Hoping to determine the number of updates on X frequency without counting duplicates. For example, there are 10 different monthly performance emails but they have been updated 10…
-
How to SUMIF in Smartsheet with multiple criteria requirements from one column
I am having difficulty transferring the formula below from Excel over to Smartsheet. Below is the current formula I need from Excel. I need Smartsheet to produce the same result. I'm new to Smartsheet and have gone through the self-help videos, directions, and pop-ups to see if I can get the formula below to work in…
-
I am trying to get a weeks to go formula to return "0" if negative.
I have a formula =(Date@row - TODAY()/7) to return the weeks to go for a date column. I want to make this formula to prevent it from showing negatives when weeks to go are in the past. I've tried: =IF(Date@row - TODAY()/7 <0, Date@row - TODAY()/7, 0) and it comes unparsable. I am thinking my dividing by 7 may be the issue?…
-
Days Remaining until Due Date (minus weekends)
I have a countdown to the due date column, but right now it includes weekends. I would like to have business days only. My original formula was: The formula I thought would work was this, but got a #invalid data type error: Any suggestions? Thank you!
-
How do you create an "AverageIf" formula for more than 1 criteria in the same column?
Hi Team, I am using a formula calculation sheet to try to work out how to create a formula to average %s in a Smartsheet where the Line of Business Column (in some cases) has more than 1 Business unit e.g. Sales and Sales (Local Sales). I have tried Average If functions, AvgCollect, AverageAnd, but have had no luck. I just…
-
Formula works unless there is no date and then it returns the dreaded #Invalid data type.
=IF(Helper@row = "1", "January", IF(Helper@row = "2", "February", IF(Helper@row = "3", "March", IF(Helper@row = "4", "April", IF(Helper@row = "5", "May", IF(Helper@row = "6", "June", IF(Helper@row = "7", "July", IF(Helper@row = "8", "August", IF(Helper@row = "9", "September", IF(Helper@row = "10", "October", IF(Helper@row…
-
How do we apply COUNTIFs with multiple conditions?
I Have 5 Columns namely Phase 1, Phase 2, Phase 3, Phase 4, Phase 5 I need a count of each row item (Less than 100%) with a condition that if a task is less than 100% in multiple columns like phase 3 and phase 4, it should be only counted in the first column (Phase 3 in this example)
-
Latest Revision - without pulling Revision History
Hello! I could use some help problem solving this. I have a smartsheet tracking revision number and date for about 240 rows of submittals. I'm trying to come up with a formula that will tell me the latest revision for each row and will auto-update as new revisions are added. The goal being to have a clean print out which…
-
Does not contain this or that TEXT
Hello, We currently have a formula that works to say if the variation row contains E-Gift, the cell will say E-Gift Card and if it contains Physical Card the cell will say Physical Gift Card. =IF(CONTAINS("E-Gift", Variation@row), "E-Gift Card", IF(CONTAINS("Physical Card", Variation@row), "Physical Gift Card")) This…