-
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…
-
Simplified Resource Management
Hello! I am attempting to develop a simplified resource management tool that would allow me to see what users are working on what projects/tasks based on the email in the Assign To column. I do not require the time allocation, just name/email and the number of assigned tasks across multiple sheets and workspaces. Some of…
-
Double check my formula
This formula turns the Harvey Ball gray even when there is a blank child. What am I missing? =IF(COUNTIF(CHILDREN(), "Red") > 0, "Red", IF(COUNTIF(CHILDREN(), "Yellow") > 0, "Yellow", IF(COUNTIF(CHILDREN(), "Green") > 0, "Green", IF(COUNTIF(CHILDREN(), "Update") >= 1, "Update", IF(COUNTIF(CHILDREN(), "Gray") =…
-
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…
-
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…
-
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…
-
New Community Experience: Search
Is there any pattern to the new Community's search? I search for "Outlook" Several pages of hits. They are not: 1. Alphabetical by author 2. Alphabetical by summary 3. Ordered by date of initial posting 4. Ordered by date of most recent comment 5. Number of responses 6. Number of likes on initial post. 7. Related to user…
-
Sum only the number values, excluding #INVALID OPERATION
Hi there, I am currently looking to set up a formula, which will sum up the numerical children value only. There are few cells in the range with "#INVALID OPERATION" (as the result of another formula from a different sheet, this will be resolved once we get all the information from our supplier in the future) and because…
