-
Average Value Errors
Hello, Was hoping someone could see what i am doing wrong here; i am attempting to take the value of two cells and average them. Both are percentages. i use the formula =AVG([average calc]33, [average calc]34) and i get the "DIVIDE BY ZERO" error. From what i read this may be due to the particular column is a dropdown list…
-
Screen blurs for lengthy formulas, or multiple parentheses
Whenever, I try to use if statements or so, the screen blurs and is very irritating to the eye. Could this be fixed ? Example : =IF(AND([Total Man hours]7 >= 1, [Total Man hours]7 <= 16), 1, IF(AND([Total Man hours]7 >= 17, [Total Man hours]7 <= 39), 2, IF(AND([Total Man hours]7 >= 40, [Total Man hours]7 <= 120), 3,…
-
Just some thoughts on Shaine and Corinne
So, I put some words down about two things: Shaine's pending departure and Corinne's pending arrival. Neither of you are mentioned by name here: http://ronin-global.com/2018/09/15/passing-the-torch/ but ... it is about you. Shaine, thanks for all you have done and Corinne, I look forward to seeing you in your new role.…
-
Critical Path Not Showing up
Hello, The critical path for my project is not displaying properly. It only highlights a few tasks while it should be highlighting many more. I have predecessors and duration enabled, and I have looked through the forums to try to fix the problem. One possible answer may be that the timeline has paths in parallel. Is there…
-
Notifications and update requests
I'm automating the update request and reminder stages to update my activities. The worksheet is not shared, but I've enabled the alert permissions for the least restrictive. The actions and alerts indicator column appears in the reminder symbol and is in pending status, but is not sending email to the requested contact.…
-
Can Viewers hide or filter columns that don't pertain to them?
My team has a spreadsheet that is shared internally (editing access) and externally (viewing access only). For the external partners that use the sheet with viewing access only, is there a way for them to hide or filter to the columns that pertain to them? They need to see all of the rows, but not all of the columns.…
-
User Stories
Is it possible to have user stories with the ability to share across a team in smartsheet? I'm looking for some functionality similar to Jira without having to leave smartsheet.
-
Trying to calculate dates
I'm trying to have smart sheets calculate a new date. I'm using =[EndDate]5+1 but it's not returning a date. What am I missing?
-
Custom Column View Templates
Is it possible to save custom views for columns? I would like to be able to show, hide, sort, and order columns via a template. I am able to filter based on specific conditions but I also need to be able to view the data a specific way.
-
Inventory management
Hello, I am trying to setup an inventory system. Does anyone know how on SmartSheet's Inventory Template to reduce inventory?
