-
Misunderstanding about what is a row (or not)
Hi, Long story short, I've been experimenting with rows and not rows. Here's a behavior I do not understand yet. I have a sheet. I create a duplicate of the sheet using Save As New I deleted all rows by selecting them and using the Delete menu item from the Row Actions menu. The sheet (both original and old) have the…
-
How to hide #UNPARSEABLE error
Hey All, I have this formula =NETDAYS(Created16, [Due Date]16) and it's working just fine. It's just give me the number days left between two dates. But, when the data cells don't have values, it gives me this error "#UNPARSEABLE". I'm guessing I need to use an "IF" statment to eliminate this error, but I don't know how to…
-
Unexpected Notifications
When notifications were recently updated in Smartsheet I began getting unexpected notifications on a Smartsheet that has been working fine with notifications for over three years now. I deleted the old notification and set up an identical new one but that didn't fix the problem. I have the alert setup to send me an email…
-
Save Issue
im experiencing a problem with saving after i add a row to a sheet. The save function works normally otherwise, but as soon as i add a new row to my very uncomplicated, reasonably sized sheet, the system gives me the error below. However, If i delete the added row, the save functionality works again.
-
Running total in Webform
I'm using an embedded Webform as an order form, where customers can select or unselect multiple services (which each have an associated cost). Does anyone know how to include a "running total" cost (or at least calculate the total cost and display it) on the actual webform before the customer hits the "order" button? I've…
-
Migrate sheets from other owners into my Workspace, then give back ownership
I have several Workspaces to which I've granted access for teams and individuals. Other sheet owners are now "coming under the fold" of the Workspace I own. To do this, I have them temporarily make me an owner of their sheet so that I can drag/drop it into my Workspace. I then want them to take back ownership of their…
-
"We received a bad request" on Outlook Add-in
I'm an IT admin trying to install the Smartsheet add-in for my users and am being faced with the "We received a bad request" error when trying to Connect with Office365 in Outlook. I have tried putting the ?prompt=admin_consent string the URL to give permissions, as well as add the add-in to the Exchange admin center. I DO…
-
Web mail notification
Hello, I am new to web forms and have a question. I created a web form, which a client will fill out to create a work order form, once the form has been filled out and it's completed, there is a link for them to enter their email address to notify them of their submission. How can I create an alert notification to the…
-
Auto Assign Tasks
I am trying to create a workflow that will change an "assigned to" cell dependent on a number of cell that will be checked, for example: If the product needs to be delivered to the customer then the "product sent" checkbox is blank triggering a " Assigned to Sales Person" if the checkbox is checked then the "assigned to"…
-
Please support "contains" in report filter
Hi smartsheet, when creating a Report, Dropdown list columns can be filtered by "is one of" but not by "contains". Please also allow "contains". Benefit would be better report templates. Kind regards Michael