-
I'm simply trying to add 2 days to a date (ex: 1/1/22) to get a date 2 days from now (ex: 1/3/22).
When I use the simple formula =Start6 + 2 it's concatenating and I'm getting 1/1/222 instead of the expected 1/3/22. All dates are in a date column (Start) and there are no dependencies in the sheet. What's going on here? I've used this function many times before and this has never happened!?
-
Compare YOY Data with Conditional Dates
Hello, I am hoping to create a comparison chart using dates from a few separate sheets. In the graph, I would like to pull a sum of Column A that is dependent on a date of Column B that is prior to today. Thank you!
-
ALERT SOMEONE
I am having problem to setup automation to alert someone. I have a column that shows 4 rows and another column that shows when the Alert someone should be sent out: Citrix/Network/PC Comm 1 - 3 weeks [column Communication Released Date: 02/17/22] =PARENT([Network Migration Date]@row) - 21 Citrix/Network/PC Comm 2 - 2 weeks…
-
count distinct function in combination with Countifs?
when I have 3 countifs (=countifs(range, condition, etc), then I need to add count(distinct(range), how to write this formula? tried several ways, but none of them works, can anyone help me?
-
Define Predecessors with Something Other than Row Number
Is there a way / formula that could be used to define a predecessor based on a value in another column, rather than having to look up the row number? For example, each row in my sheet has a unique ID, and I want to be able to say the row(s) that match a certain list of ID numbers are predecessors to the row I'm in.
-
Counting the results of and Index match not functioning...
Hello, Has any ever run into an issue where you are using an index match or VLookup to retrieve text, lets say the category for a row and then you want to count how many rows are assigned to that category. Index(Match) formula is working great. But when I build the Countif in the summary field I get #No Match for all of…
-
Moving rows/updating cells
I manage a portfolio of projects which I have to report on. I'm a Pro user, so I don't have the functionality that could probably make this task very easy. My project managers are required to use a company solution (not smart sheet to create project plans and updates). I've created a smart sheet that lists all of the…
-
Is it possible to get a count in Sheet Summary with the following equation?
=IF([CFO Install]@row = "yes, me only", 1, IF([CFO Install]@row = "Yes, my spouse and I", 2, IF([CFO Install]@row = "Unable to attend", 0))) I keep getting #unparseable. I tried COUNTIF(s), SUMIF(s) Right now I have been creating a separate column in my sheet with the formula to get the sum. I would like to clean up my…
-
Nested formula with sheet references help
I need a formula that will: look up a name listed on sheet #1 on Sheet #2 and pull the most recent date they completed training. So far I have tried two formula combinations and neither has worked. =IF({Training Data Range 1 - Name} = Name@row, MAX({Training Data Range 2 - Date})) #INVALID OPERATION =VLOOKUP(Name@row,…
-
sum values of a column in another sheet based on the column position
Hi all, Is there any way to sum a certain column in another sheet based on the column position? I think of having a reference like {another sheet range} with a range of e.g. 4 columns. I would like to sum the values of the second column, but do not know how to make this. SUM(INDEX({another sheet range}, 2)) will not work,…