-
SUMIFS Function with Multiple Column Sum Range
I want to sum values over a two column range using multiple criteria but when I include more than one column in the sum range I get a #MISSING OR INVALID PARAMETERS error message. When I back off the sum range to a single column it works fine. Is the sum range in the SUMIFS function restricted to a single column?
-
Alerts/Notifications with messages
I have a sheet named inspection sheet, on this sheet is several inspections that are due at different times of the week, month and year. In order to make sure these inspections are carried out I have listed the inspections in rows, on each row is the date it is due and the person it is assigned to. Therefore to ensure…
-
Future Developments
I am a new user to Smartsheet. Still testing it out for the 30-Day Trial. I really like Smartsheet, but am a bit concerned about becoming too involved with it because it does lack some functionality I was hoping for. That said, only a few of the upper end (expensive) project management programs seem to do what I want.…
-
Attachments
I have been using SmartSheet for about a year now. It is wonderful and suits all of our needs for collaboration with our external customers. One item i am struggling with is documents, I love using workspaces but with the number of attachments that we have per customer i would like to have the ability to do foldering for…
-
New data detection
Hi I was trying to find if there are ways for smartsheet to push new row data into a database. Like when Person A modified Document X. Then through API smartsheet will send the newly modified data (rows) to the database to add to the database. I'm not sure if this can be achvied or not. But i do see that it can send out…
-
Formulas Dissappear
Is there a way to keep the formulas from dissappearing? I have a formula set to check if the checkbox is checked but if the checkbox is checked independently from the main checkbox then the formula seems to dissappear. Also, is there a way to view the form as another type of user, ie...viewer, or editor? Thanks YouTube of…
-
Smartsheet in Powerpoint - Not Gantt Timeline
I want to either export or copy and paste my Smartsheet into a Powerpoint table once a week. The text has to be editable after I paste it. When I copy and paste, it loses all formatting. The transfer process is going to be used by my director, and I can't ask him to do a lot of transformations or steps to reach the…
-
Thumb nails for inventory
I recall in one of your newsletters that you were working on adding thumbnails to add to a column for inventory sheets. It this still in the works? If so when will it be added. I want to create an inventory of all our marketing images and this would be extremely useful! Thanks Very much, Rose
-
Supplier Order Management
Hi, i have signed up for the trail version to see if we can design a smartsheet for supplier order management. We are a small bookshop and our customers send us their orders via email and websites. We then check stocks in our warehouse if available we supply and if not then we inform "ORDERS DEPARTMENT". The Department…
-
Smartsheet MRP/ERP
Hi all, Has anyone used Smartsheet in the capacity of a simple MRP or inventory management system? If so, it would be great if some examples could be shared. Especially where teams have used the Smartsheet and Google Apps integration to serve as a dynamic ERP/MRP system? I've read a couple of articles describing this being…