-
Filter - "at least one condition" - wrong results
Hi, I may be going mad, but I cannot get a filter with at least 1 of 2 conditions to work. Maybe my boolean is getting rusty... I have 2 columns with monetary values. I only want to show rows where at least one of these is bigger than zero. Nothing complicated. The settings are attached in the screenshot below. However I…
-
Using a formula to subtract 1 box out of "box inventory" when I record a sale in "Sales"
Hello, We have a basic retail business selling iPhones and what I would like to do is create some type of formula so when I enter a sale into my Sales Sheet it will link to my Box Inventory Sheet AND it will subtract the correct box out of the inventory based off of its Model and Color. I'm not any good with creating…
-
Privacy Shield Application
Can I confirm progress, another thread says this self-certification expected to be completed by end of Q1-2017, I've had to hold off a wider rollout of some functionality to our business until this is resolved.
-
telephone integration
I've been asked if SS can integrate with a telephone system so that phone numbers in a sheet can be dialled directly from within SS? We use SS to track customer prospecting and to log any contact with potential customers. Being able to call directly and then to log the date/time etc as well as prompt follow up would be a…
-
Workaround for Editing a Report Without Full Access
Hi, I have a crucial missing piece to a workflow of mine which would allow my customers to edit my Smartsheet Reports in order to make their "selections" on my products. The issue I'm having is that I cannot share the sheets associated with my reports with my customers because there is information on those sheets that I…
-
Totaling a column with check boxes
I couldn't find an answer that solved my problem so am asking this question. I am trying to sum up a column where some of the fields are checked and some are not. Can you please help me? I have tried looking at the SUMIF calculations and keep getting the #BOOLEAN EXPECTED error. Thanks in advance. Linda
-
All videos simple - don't show realty use of training needs
Anyone noticed that all trainging videos are so simple of solutions they really don't help with much beyond the most basic. Like conditional formatting - show me how to deal with wanting multiple columns to change format based on one criteria - not a whole row. How do you do that? How many formats do you really need to…
-
Page Layout with a table and summaries
Smartsheet often shows a nice calculation at the top of a sheet. Say a list of dealers. The first five lines of the sheet have a nice summary box with the number of dealer in each state calculated or soemthing like that. Now the sheet column headers are really matching the data table not the summary table. So name,…
-
Advanced Notifications options - add scheduled notifications.
I like the improved Notifications functionality and would like to add one more suggestion. Can you add a "Delivery" capability so that the frequency/Date/Time for the notification can be customized? This is similar to the existing functionality in SmartSheet Update Requests.
-
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