-
Cell is considered "changed" when it goes from Blank to Filled - Why
I have a sheet set up that populates rows with information filled out from a Smartsheet form. Rows are only added by filling out the form. When a row is added (i.e. form is submitted) a notification is sent out to a mailing list of individuals. This all works fine. I have a separate workflow notification in the same sheet…
-
Integrate with Bank Feed
Can I integrate a sheet with my bank (Lloyds) to automatically download new statement lines every 30 mins or so. I have to login to my bank and copy the data across all the time and would like to automate it if possible.
-
Inventory
Is there a training video to show us how to do the inventory and features? We want to use this feature but I need some training.
-
Help with PDF Fillable Files on smartsheet app
I have salesman that use pdf fillable forms for company use. I created a sheet that has all the forms in it as attachments. When using the desktop version they click on the attachment and it brings up the file and they file in the information and can print it. They are unable to do this in there smartsheet app for IOS. I…
-
Card View - Card Layout
We use smartsheet as a CRM/Project management. Each Row is a new project we are quoting. In the rows we have over 25 different columns. The way we usually view and enter data in them is in card view. The problem is I would like to change the layout when viewing in card view, not just the order they are in, but actually…
-
help with average formula
Hi, I am having trouble with getting an average of a column. its a formula based column and since some rows dont meet all the criteria, some rows state INDEX DATA. How do I find the average of the numbers in the column using a formula?
-
Return 1st column value if 2nd and 3rd column is blank
Hello, I am trying to come up with a solution for my smartsheet involving 4 columns (4th being the result column). I wanted to return the value from the 1st column whenever 2nd and 3rd column are blank, if not return the value from either 2nd or 3rd column. These columns contains dates by the way. Sent (1st) ; Won (2nd) ;…
-
Apply Formula to Entire Column
I'm trying to automatically apply a formula to an entire column that concatenates info from cells in a given row into a document name, once data is entered into those cells. The only way I've been able to accomplish this so far is to just copy/ paste or drag the formula as data is entered in a new row, but I'd like it to…
-
iPad Dashboard Navigation
When I create a dashboard, I am unable to create a link to a specific folder within the same workspace that is accessible with an iPad. I've tried it a few different ways (URL's, smartsheet shortcuts, etc.) but whenever I press on the link, it just navigates me back, out of whatever workspace I'm in, to the home tab of the…
-
Workflow utilizing data uploader and a template
So here at my company, we have a project template. This template contains many setting, functions, workflows and conditional formats that help organize our information. We currently generate an excel template similar to the one in smartsheets then copy paste into our template. My question is regarding the best way to get…
