-
Counting non blank cells
How might one count non blank cells in a non-contiguous range in Smartsheet? =SUM(COUNTIF(INDIRECT({'Range","Range"}),"<>" & "")) is not supported. Thanks.
-
Mapping with Smartsheet Labs
My company is a private emergency response service. We were very excited when Smartsheet Labs came along and presented us with the ability to map our clients adresses. However this feature turned out less than great due to it using Bing rather than google maps. Adresses that should be easy to locate simply wont map on…
-
basic math in Web Form
I would like to see the ability to add, subtract, multiply and divide in a Web-form. Asking for financial information and need to add 5 or 6 boxes to have a subtotal. (at least one box is the multiple of 2 other boxes), Then deduct optional box for a final total on Web-Form. Now I ask the person filling out the form to do…
-
Last Column not available for view. -- recovered!
I have a large sheet (48-50 columns by 80 rows). I can not see the last column. It has a formula that displays either "not done" or "done". I use it to highlight "done" rows in green. I was working on another indicator and wanted to access that column and couldn't scroll over to it. Have I met a limit on the width of the…
-
Formula help...
I've tried a formula that seems to work, in that it doesn't give me the lovely "Unparseable" or "Missing Operator" message. Here's the scenario: If Column A (text column) contains "These words" then Column D (date column) = Column B (date column). Column A does contains the needed words, and Column B is a date. But Column…
-
Appsheet
When I try to "Make New App" I get this error message "Not Found → Unable to create folder '/appsheet/data/NewApp-115927' and copy data files due to: Not Found"
-
Unicode Text Symbols are extremely useful
Please send me an email if you would like to be added to the workspace. kriswalsh@gmail.com I love Smartsheet's native symbols and use them all the time. That being said, there are times when I wish I had more options or flexibility with them. I am sharing the following with the hope that: 1. Someone finds it useful. 2.…
-
Adding a licensed user - 1 at a time?
Good afternoon, In the recent past, we have added one licensed user to our existing account. However, another area in our non-profit, who have their own separate licensed account, have been told they have to purchase 3 licenses at a time to keep the "grandfathered" licese price. On our account, when I click "Upgrade" it…
-
Smartsheet User Interface
Can the user interface for Smartsheet be reskinned to match our corporate colors or design aesthetic?
-
Date Formulas Calculating Back From Deadline with Gantt Functionality
Hello Team Spreadsheet, Ultimately we'd like our company to enter a date that they would like to have their marketing materials and have smartsheet automatically calculate key dates prior to this date including the initial submission date which should be around 5 weeks prior to the end date. Here is our marketing team's…
