-
IF/INDEX function returning #INVALID DATA TYPE
In my function below i am trying to fill the actual start date column with a new date if the predecessor task's duration was extended. ive replaced the Predecessors@row with a number value and the formula returned actual dates, so i suspect this is where i incorrectly identify a row number in the index function. i also…
-
Can a cell-specific formula be applied to a column?
Is it possible to apply a function to an entire column that is cell-specific? I have a Start Date, End Date, and a Duration column where I’d like the Duration column to calculate the number of networkdays between the start and end dates in the row. Currently, it looks like this: (yes, I know there are negative days- I'll…
-
Auto Numbered Parents, but not Children
Yes, I know. This topic has been floating around for a while and there appears to be multiple options/solutions provided, but I do not think they apply. Asking the braintrust... First, I think it would be helpful to think of how a standard Sales Order or Purchase Order form would operate within an ERP with a Header and…
-
Is there a formula to use COUNTIF with OR?
I am trying to count rows base on if one of three columns have been completed. Two of the columns are checkbox datatypes and the other is text. If any one of them contains a value(or is checked) them I want it counted. Here's what I have: =COUNTIFS([SAME PERSON]:[SAME PERSON], 1, [DON'T CREATE]:[DON'T CREATE], 1, [NEW…
-
Remove duplicates from a row?
Is there a way to remove duplicate zip codes in a row of columns so only unique zip codes will be available when I concatenate them all into a combined zip code column? Example: If I have 4 columns of zip codes and Col 1 and Col 4 are duplicates, I only want to show Col 1's Zip Code once when I combined all the columns…
-
HELP!!!
=COUNTIFS({Belleville - 1N Front St (task) Status}, [Not Started]@row, {Belleville - 1N Front St (task) Status}, "Children" I am trying to create a formula for my in progress tasks. My countifs keeps changing to not started and the formula is giving me an error. My total In Progress is calculating wrong bc it is including…
-
vlookup error message
What am i doing wrong with my formula: =VLOOKUP(MSN@row, {Conversion History 12.15}, 6, false)? I update my reference sheet every month and every month i always get error message #incorrect argument set when i try to update. I tried both updating the reference sheet and writing the formula from scratch but always get this…
-
#UNPARSEABLE error
Can anyone help identify the problem here? It is a simple formula to sum the numbers if 2 conditions are met and works perfectly in excel but Smartsheet keeps giving this error. =SUMIFS({DHR Team Time off Planner 2023 Range 1}, {DHR Team Time off Planner 2023}, [DHR Team Member]@row, {DHR Team Time off Planner 2023 Range…
-
Spreading a budget over a number of months depending on activity date
Hi All, I have a sheet which tracks marketing activity and the cost of it. Our activity can sometimes be one day, and other times it can run over several months. I have added helper columns for each month and named "January 2024", "February 2024" and so on where the purpose is to assign an appropriate amount of budget in…
-
How to create a formula to count # of values in a multi-value cell + other criteria using COUNTIFS?
Hello, I'm trying to count a value from a multi-value cell considering more than one criteria located in other columns. I'm trying using this formula: =COUNTIFS([LSP Name]:[LSP Name], CONTAINS("CNWQ", @cell), Active:Active, CONTAINS("Active", @cell), Function:Function, CONTAINS("MULTIPLE", @cell)) but is not working. Is…