-
Dragon Naturally Speaking
Does anyone else use Dragon Naturally Speaking when entering data into Smart Sheets? My expience has been negative. I can go to any other website, and enter text etc. However, SmartSheets does not allow for text to be entered in this matter. I am forced to use dictation box transfers, which is sort of a pain. Thoughts
-
Drag and drop from Google Photos
Is there a way (or an add in) to drag or attach photos directly from Google photos to the attachment window in a sheet? I know I can upload from a Google drive but that requires me to save my photos to my drive. The other option is to save them to my computer. It's cumbersome to do that.
-
Workspace Enhancement
Good morning, As our company grows, so does the workspace in smartsheet. Can I add a request to allow notifications from the workspace without having to go into individual sheets to change the automations please. I have about 40 sheets I need to add someone to and have to do this individually through all sheets. Thanks!
-
Checklist for Airbnb Cleaners
Hi all! I want to create a checklist for the cleaners who turn over my airbnb properties. I know how to create this checklist but there are a few specific things that I need it to do and can't figure out how. Any advice would be appreciated! 1) This checklist will need to be filled out each clean. That means there needs to…
-
Sumif Formula
Hi, I'm having problem with my formula below. If I update the column 2 to reference "Amount Invoiced", it automatically change the formula in Column 1 to "AmountInvoiced". I need Column 1 to only reference PO Amount and not Amount Invoiced. See below sample formula that I input on the sheet. Column 1 =SUMIF({FY19 MASTER PO…
-
Is Picklist always Strict through the API?
I'm trying to update cells via the API and one the cells is in a Dropdown list column. However, when the API tries to add a value to the cell. I'm getting a 1042, "The value for cell in column 7098131356849892, beagle, did not conform to the strict requirements for type PICKLIST." However, I've checked the sheet, the value…
-
How to tell if Multiple Invoices have all been processed
I've created a sheet that we use to track our projects. For each project there could be one invoice we need to pay, or multiple, as the project progresses when the invoice is processed and the checks are sent out to our partners there is a column that indicates the date the invoice processing is complete. I've created a…
-
Reports
Hi, Recently I create an report file, where I want him to show certain columns. I choose for "Where" condition the location from where i want him to extract the info. But if i will create another new sheet in that folder, even the entire folder is choosen for report, he dosn/t know to automatic include that new sheet in my…
-
Circular Reference Won't Go Away
Hi, I'm working on fairly large sheets that reference many other sheets. My main summary sheet is doing SUMIFS formulas to summarize and sum to a higher level. The summary sheet column is showing a Circular Reference error. I found the error on my raw sheet and corrected. However the main summary file still shows a…
-
Gantt rollup for multiple projects
We are trying to rollup multiple project sheets that have tied in metrics. The gantt view is not allowing us to have the dependency arrows on our rollup. Do you have any suggestions how to create this? We have multiple tasks on our project sheets that have dependencies but our phases do not. I tried copying the dependency…
