-
Scanning a Barcode
Does anyone currently know if smartsheet is capable of capturing data from a bar code?
-
Time of Day
I have seen several forums related to Time of Day as a column option. This appears to be ongoing for nearly (4) years as a feature enhancement. Can someone provide an update and a simple workaround (not a long-winded formula option)?
-
COUNTIF Formula for when a cell contains a specific word/phrase?
I'm trying to create a formula that allows me to count the number of times the word "Postcard", for example, appears in a list in a column. I am referencing a column in another sheet to do so. However, nothing I've tried works. My instinct was to try =COUNTIF({2018 Open Enrollment Feedback Range 1}, "Postcard"). However,…
-
Return entire row when value is matched in another sheet
I have a source sheet with hundreds of rows of entries. One of the columns is named Property. There are many different values under this column. I have a destination sheet for each one of these possible values (in this case, a property). What I would like is to have have any rows in the source sheet which match a specific…
-
Export smart sheet
Hi, I wish to export existing sheet data by last year month wise, i. e. i am using smart sheet since 2017 to till date, i am using smart sheet to maintain data and with getting updated by team, i wish to be have a data month wise which i haven't saved it on my PC and now i wish to see month wise data. please guide me how i…
-
Hyperlinking Templates
Is there any way to hyperlink a template from a Smartsheet?
-
Using a sheet to assign a project number
We use google docs currently for our company to input data about clients, and be assigned a specific project number. We have ~30 employees in the project book pulling these file numbers at any given time, so we like the transparency of seeing who is on what line, so as not to overwrite their data. We then take that project…
-
Workspace Notifications - not individual sheets
I dont believe this is possible and if you not i'd like to request this as a feature. Some of my workspaces can have up to 28 or 30 sheets in them, all related to the same project. As the owner i would like to be notified of any changes within these 28 -30 sheets, but dont want to have to repeat the process of setting up…
-
Using Web Form to Update different sheets
I am using Smart Sheets as a work order tracking tool for multiple properties. I would like to use one standard web form with either a drop down list or check box of properties. When a user selects the property they need service, the sheet attached to the property would be updated. One web form with direction to update…
-
Automating updates from shared Excel doc to a Smartsheet doc
Is there a way to automate updates from a shared Excel file to a Smartsheet doc? I am currently manually entering data from an Excel file into a Smartsheet to update the information on a Sight. It would be great if the data was automatically updated in the Smartsheet when the shared Excel file is updated. Is that possible?…
