Trending in Formulas and Functions
-
SUMIFS formula syntax
Hi, I believe I'm needing help with the syntax for the SUMIFS formula. See the below photo with example data: I am wanting to total the revenue generated for each department (category) and sub department (topic) only if the status is labeled "Won" - which the above screenshot would not be included in the total. The "Topic"…
-
Return Multiple Values from a Lookup of Multiple Values
I have a training feedback form, and classes have multiple instructors. When the student picks multiple instructors, I need to look up the corresponding email for each instructor, usually only 2. you can see from my screen shot, I am getting an error if there is 2 to lookup, is this even possible or what is a recommended…
-
Technical Issues with Formulas in Smartsheet
I am currently experiencing significant technical issues with complex formulas in my Smartsheet. The formulas are extensive and connect multiple sheets, each containing over 3000 rows. Unfortunately, I am receiving error messages indicating that the formulas are unable to access all the rows, and I am also encountering…