-
Fill a client order
Good morning, can anybody share a sheet or idea to register the sale order. I am novel in smart sheet and now I solve using a list to slect or chose a data of the client, and then register it like, name. adress, state, etc, but it takes some time and space. Thank you
-
Imported sheet formulas not all working
I imported my sales tracking sheet and most of the formulas are working but some of them are not. this is what they say: #UNPARSEABLE#BLOCKED#BLOCKED Here is a screenshot of what I have in some cells. https://screencast.com/t/J1Rvx4iz0 I don't know how to fix this.
-
Locking Cells/Columns in a Report
Hi Smartsheet - I recently created a series of report in smartsheets that pull specific pieces of information for departments so that managers can see their respective things and provide updates. However, unlike a regular sheet, where you can lock certain columns so as to prevent users from being able to edited field, we…
-
I would like to send daily reminders of a row to the employee of that particular row till the status
Hi, I want to send daily remainders of a row to the employee of that perticular row till the status colomn shows finished. The colomn names in my sheet are : 1, start date : system generated date and time( this is not visible in the reminder) 2.end date : we can utilize this based on the status colomn 3.emplyoee-1,…
-
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…