-
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…
-
Formula to count check boxes in row one of column
I have a questionnaire with multiple columns. Responses are either check boxes or comments. I want to summarise the total check boxes in each column. I can add a column and write a formula to total the checkboxes, but the error message "#1 or 0 expected" appears when the formula is in the same column as the check boxes.…
-
Merging inventory
I have an inventory I do each month and have a fairly simple question but not sure what is the best way to complete this task. I have 3 columns. ItemNumber, ItemName, and TotalQTY. The first sheet is what I actually have on hand in the warehouse the second sheet is what our system says we should have. So far very simple.…