Sign in to join the conversation:
Hey everyone,
I have 12 individual project sheets with multiple columns. I want to pick up 7 columns from them and link all the data from those 12 sheets into a super sheet.
Is this possible in SS?
I'm trying to get a formula for a sheet summary value to calculate average duration of rows where Risk Type = "EDAM Risk" and Status = "Resolved - Mitigated" or "Resolved - Decision." Assuming: Duration is in a column named Duration Risk Type is in a column named Type Status is in a column named Status I've been using the…
Hi, I am using this formula =IF([Warranty Status]@row = "Warranty Expired", IF(AND([Asset Status]@row = "In-Stock), "Out Of Warranty","")) Its says the formula is unparseable. I can't figure out the issue with the formula. Help is appreciated.
I am trying to write a cross sheet formula and keep getting the incorrect argument set error. The formula I wrote is: =SUMIFS({Total Poles}, {Vendor}, "ALLO", {Date}, >=TODAY(-30)) My formula is stating that I sound sum the amount of poles where the vendor column is Allo and where the date column lists dates within the…
