-
SUMIFS - Multiple criteria syntax guidance
Hello, I am am struggling to get SUMIFS working with multiple criteria values. I want to sum data based on Month column and then by probability column. Here are a couple methods I have tried but I cannot seem to figure out what I need to do in order to make it work. =SUMIFS(Month:Month, "March", Probability:Probability,…
-
Exchange Server 2010 or 2013 (On prem)
Any update on support for on premise implementations of Outlook platforms (Exchange 2010 or 2013) integrating with SmartSheet? We won't be utilizing Office365 at our firm. Thanks!
-
Combining COUNTIF and COUNT(CHILDREN) formulas
Is there a way to create a single count formula that will return the number of rows using two criteria? I need the number of rows with column A = Abby and column F = MONTH(@cell) = 2
-
Drop downs issues in form
Trying to build a customer feedback form. No idea why but the form does not save the dropdowns as I have entered them. I enter and save it like this 5 - Very Satisfied 4 - Satisfied 3 - Neutral 2 - Unsatisfied 1 - Very Unsatisfied When I open the form it looks like this 1 - Very Unsatisfied 5 - Very Satisfied 4 - Satisfied…
-
Magento
Has anyone got any positive experience with linking Magento to Smartsheet? eg just to populate a sheet with orders recived etc.
-
Automatically add rows when report refreshes
I have a report that's running every day against a single parent row to grab totals. A few cells of that one, single, lonely row. I'm looking for a way to automatically copy the report's information into another sheet daily, that way, over a period of 1 week, 1 month, etc., we can see the changes in the totals. This is…
-
Not new, but I wonder if there is an smart advance tutorial for Smartsheet for not so smart people
I love using Smartsheet, but I am almost positive I am using just 0.00001% of its capabilities. I appreciate your input.
-
IF(AND(DATE(YEAR
Hi Team, If(and( this MONTH/YEAR date matches the [Comms Due Date]2 MONTH/YEAR date then return 2% of [Current Month Sales]2 dollar value or nothing. (Text number cell) =IF(AND(DATE(YEAR([Comms Due Date]2), MONTH([Comms Due Date]2), ([Current Month Sales]2,*2,''-"))))
-
Hyperlinking Images?
Hello- I am working on converting an inventory spreadsheet that is currently in excel and moving it over to Smartsheet for additional functionality. I would like to include images - is it possible to actually hyperlink an image once it is attached? Thank you!
-
Monday of date
I have an installation date column and a "week of" column. In our "week of" column, we keep the date of the Monday before. As an example, if the installation date is 1/19/17, the "Week of" column should be 1/16/17. Or, if the date is on a Monday, (Installation 1/23/17), the "Week of" column should be the same as the…
