-
SUMIFS - multiple criteria refrencing another sheet
Hello - I need help with a SUMIFS formula referencing another sheet. I would like it to sum the tech count column if the request type is "FSA" and the FW01 column is "true" Here is my formula that is currently not working: =SUMIFS({Tech Count Range 1}, {Tech Count Range 2}, "FSA", {Tech Count Range 3}, "true"}) Tech Count…
-
IF(OR(AND?
I am having trouble with a formula. I am not sure what the heck I am doing wrong here, but I know there are some formula geniuses here that can help me lol. I am trying to return a Red ball if the category is an output or project and the expected completion date is in the past. If it's not, I want it to pull whatever is in…
-
Combine two separate contact cells into one cell.
With the new update to Vlookup adding contact list functionality, would there be a way to combine two individual contact cells into one cell with both contacts using an equation/formula?
-
Is it possible to create an "If" statement that includes a hyperlink?
I have a column of data which reflects the status of a project. Statuses include "Completed", "On Next Report" etc. I'd like to embed the report schedule into the cell when the project status is "On Next Report" so viewers can easily click and see when the next report will be published. In my head, this is something like…
-
How to use vLookup for other sheets
Hello, I've been trying to use vlookup to find data from a datasheet Sheet A contains a column 1 with "My Name". Sheet B contains column 1 with "Name" and "Number" I want a column in sheet A that looks for the corresponding name in sheet B and returns its number. I've looked up tutorials on this but there doesn't appear to…
-
How to compare 2 sheets and harvest data from one sheet onto the second sheet
I am comparing 2 versions of a product BOM(one is flat, and the other is organized by sub assemblies and lists critical components). Each BOM is stored in its own Smartsheet Grid. One BOM has vendor and vendor part number information. I want to harvest the vendor and vendor part information from one of the BOMs and insert…
-
What formulae touse to get the count of status of A In Progress/Not Started and the same for B
-
Odd way to emulate excel formula counta()
Needed to count all cells for a project, found how to do it, and am posting it here in case it helps someone else. on range a =countifs(A:A,@cell = @cell)
-
COUNTIFS Errors
I'm trying to create a Sheet Summary field formula that will count up the number of "Yes" (formula-generated, if that matters) cells in a column if the date, in another column on that row, falls within a given month/year range. This one seems to be working... I think: =IFERROR((COUNTIFS(OTD:OTD, OR(@cell = "Yes", @cell =…
-
#unparseable error when creating a symbol formula
Hi, I am trying to create a formula to return a status symbol based on the date on a cell. Basically, I have a column called "Date PRF Received" and I want to put a formula in the next column to show a Red light if the date is prior to today's date and Green if the day is still in the future. I am using the formula:…