-
Tire Maintenance - Form / Spreadsheet Assistance
Hello All, Today is my first day (YAY!). I'm digging Smartsheet thus far, although, I'm looking for suggestions. I've been tasked with creating a Tire Maintenance Program. So far I've put the basic asset information (Year, Make, Model, VIN, Tire Size(s). Screen shot will help make sense of this. The key part is trying to…
-
OCR FOR THE MOBILE APP
We would like to use the mobile app for expense reports. We would like to be able to take a picture of receipts and have the app recognize the data and auto fill forms (OCR). Is that possible using the Smartsheet app?
-
Creating Different Update Request Formats
I send update requests every day. However, when I send them, I have to keep removing some of the columns as those that I remove are not necessary for the person to see. Is there a way that I can save an update request format with those columns removed so I can quickly choose the right formats for the specific person I am…
-
Sum of column items respecting the filter
Hi all, I've started using Smartsheet recently, so I am sorry if this is a newbie question ;) I've tried to search for a solution, but nothing specific about this came up. Anyway, I got the column SUM as open-ended, summing all rows correctly. But when I enable a filter, for example only seeing rows in last 60 days, the…
-
Help with If ISBLANK or statement
I'd like a column to populate "late" based on whether another column has a date in it or is blank. Does anyone have any experience with nesting this type of formula?
-
Mobile Web Form
I'm new to Smart Sheet and it seems that it could work well for our company. One of the first Qs I have is how to 'use' a web form. I have created one but I don't see how to make the form apear on my iphone. The 'sheet' is visible but not the web form. What am I missing? Thanks.
-
PERSONAL BUDGET / FINANCES / EXPENSES
Can anyone provide examples on how they use Smartsheet for their personal budget / finances / expenses? Smartsheet has a template but I am curious to see how others use Smartsheet for this topic. Feel free to comment with screen shots attached and blackout any personal info.
-
How would I add an attachment via a Webform?
I am working on a webform that would request actions to help track and manage contracts. Is there a way to add file(s)/attachments to the smartsheet via a Webform?
-
Populating a sheet from a Webform
Is there any capabilities regarding populating multiple lines of a sheet from a web form? My company uses Smartsheet as an AP tool where vendors submit there invoices through the web form I created. My company has over 150 sites nationwide and over 300 globally, so some vendors we have are global as well and invoice 50-100…
-
Sheet Column References in Equations
Is there a way to convert a column reference to a number like you can in excel? My problem is I'm to trying to input an equation that is a simple sum equation referenced to an input cell "x". Whatever number is put in for "x", will add to the column length that sum equation is good for, however when I try to do this, I get…