-
Showing Only the Parent Rows in a Dashboard Chart
Hi - I have created a dashboard to show pie charts of my data. My problem is that the pie chart wants to include every single row as a data point, I only want to show the parent rows and not the children. I used the formula "=Count(Ancestors(row))". This gives me a 0,1,or 2 based on how many ancestors the row has. But I'm…
-
Formula takes a few seconds to populate after the sheet is opened
What could be the root cause for a formula not populating until a few seconds after opening a worksheet? I built a formula off of a contact cell that references a roster to show an individuals manager but unlike all the other formulas in the sheet, this one takes a few seconds to calculate, it is throwing off my reports as…
-
if(and formula
I'm having trouble with a "if(and" formula. =IF(AND({KCPL Hours_ASSIGNED TO} = [Assigned To]@row, {KCPL Hours_TASK} = [Task Name]@row, {KCPL Hours_Project Number} = [Task Name]6), "1", "2") But I get #INVALID OPERATION error message. Any help would greatly be appreciated. Thanks, David
-
Referencing another sheet for selective information
Any help with this would be appreciated. I haven't been able to come up with a formula that would check a reference sheet for a value and pull the data from another column to populate the current form. I expect it would be a compound formula with an IF and maybe a INDEX, but I'm having difficulty narrowing it down. - Any…
-
Time/Date Stamp formulas
Hi, I am trying to auto populate a time date stamp when a cell is filled in on a row. Ex Submission Status then I need to create a formula to populate a due date based on the time date stamp and based on Priority Levels Priority Level (Business Days) High - 3 days Medium - 5 days Low - 10 days NBD<12pm- (Next Business…
-
Help on formula
Hi I am fairly new to Smartsheet (3 whole days) 2 questions. I have a dropdown box titled 'Finding Rating' with 3 values: Conformance, Minor Conformance and Major Conformance. 1.Needed a count of each type (so i can create a graphs, on dashboard), I created another 3 columns titled Conformance, Minor Conformance and Major…
-
Convert week numbers back to physical dates
Hi, I am new to smatsheet. I have transferred an excel file into smartsheet. After some use I have decided I don't want to use week numbers, but dates so I can leverage the power of smartsheeet. I found the following code =DATE(2019, 1, 1) + 7 * ([Task Start]1 - 1) It was originally for 2018 so i simply change the 2018 to…
-
Formula to count fields that are not blank
I am just getting familiar with smartsheets and am having a problem convert a spreadsheet that contains a formula that I really need. This formula currently works well in Excel to count cells that contain dates so if any cells are blank it won't count the cell. This is the formula that works in Excel…
-
Don't Count if Cell is Bank
Hi All, I am using a checkbox formula to count the status of a task. Is there a way to also include to not include blank cells in the count? My formula is =IF([1 Rough Draft Writing Status]11 = "Not Started", 1, 0) I want to drag the formula down but I also have rows that don't have anything in the status column because…
-
SUMIFS with multiple matches
I am trying to create a Smartsheet SUMIFS formula where if the value in a cell in column 1 is not blank, and the value in a cell in column 2 is US Commercial, and the value in a cell in column 3 is 2019 and the value in a cell in column 4 is 4.. I.e. for any rows where there is a match for - deal id is not blank, where…
