I want to create a cross-sheet formula and have two conditions for the formula to go through to result in a value.
If the value in column1 is 1 and column2 is VendorX then sum all values in column3 corresponding to the conditions.
I am not sure if the SUMIF will work for this.
You should be able to use SUMIFS which checks multiple ranges, like this:
=SUMIFS([Column 3]:[Column 3], [Column 1]:[Column 1], @cell = 1, [Column 2]:[Column 2], @cell = "VendorX")
I'll try this and let you know if it works! Thanks!
It worked!!! Thank you!
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
I have a formula that returns the number of Volunteers we have signed up IF they are assigned to any stand (it will not count them if they are assigned Waitlist or $$). My current formula that IS working is: =COUNTIFS((Contact:Contact), <>"", (STAND:STAND), <>"*Waitlist", (STAND:STAND), <>"$$") It works great. However, I…
See attached document for details, but I need to select email addresses from an external sheet where the contents of a multi-select column is used as the criteria. This was my attempt. No errors, but it doesn't return anything. =JOIN(COLLECT({Email Address}, {Dealer Name}, HAS(@cell, DEALER@row)), CHAR(10))
Hi All! Does anyone know why sometimes it shows " ' " in a cell when an excel file is imported? I´m having a hard time when it happens because VLOOKUP formula cannot find the information ... Thank you & Regards, Camila