-
Calculating average difference in dates between two columns
Hi I am trying to find the average time to complete a task without adding additional columns in my sheet. I would like to set it up in the sheet summary for easy reporting. In excel I would use the following formula. If a cell is blank the row will not be calculated as part of the average.…
-
Max number of rows on a dashboard
I have a dashboard with 185 rows that I have added to a Dashboard. I don't want users to be able to click on it to view the full report, however Smartsheet seems to be limiting the number of rows that can be viewed via the Dashboard. Is there a way to increase the number of rows viewable on the dashboard? If not, is there…
-
Intake Requests Without Form
I am trying to see if there is a way to create rows via email without having our employees use a form. We are currently receiving a large amount of requests from our branch personnel to our corporate office. These are specific requests for a specific department. The requests are currently coming into our Jira help-desk via…
-
COUNTIFS with Due Date and Status
Hi! I've been trying to use a COUNTIFS formula to determine how many projects are 5 days out from the due date, as well as, which projects are either blank or In Progress. I definitely don't have the formula formatted correctly so it is not working. Any help you can provide is greatly appreciated!
-
Summary
I am trying to find a way to do a monthly summary of the number items each month in Published, and Expired Alert Status. Does anyone know what would be the best way to complete this? Thanks!
-
Attempting to add a column to report that is under Summary task
I have a sheet of active projects. I am trying to create a report filter on the Status column. However Status does not show up as a column either in row report or summary report. The first task is a summary task and all other tasks below are children.
-
I don't want grid lines to display on my dashboard. Can these be removed (or made not to show)?
Using the Employee Contact List - Template Set, I have created an employee contact list, with reports broken out by teams. When I add the reports to my dashboard, the grid lines show. Is it possible to remove the lines so that just the text shows? Thank you! Pam
-
Recommended Trainings to learn formulas? Beginner to Advanced
Hello! I went to Engage19, participated in all formula learning sessions and have even seen the recordings of Engage18. With this I've just been exposed to possibilities and have applied them by copy pasting the formulas, but I don't really understand the logic of it to actually be able to build my own or think of…
-
Parent vs child flag
Hello, I'm wondering whether it is possible or not to write a formula to indicate whether a certain cell is a parent or a child. The sheet I'm working with only has 2 levels, and I'd like to create a column that is able to delineate the two. My initial thought is something along the lines of =IF([Cell 1] = CHILDREN(), 1,…
-
Update Forms: Can they be created without the automated email link generation?
I have an intake sheet with multiple projects and instead of sending a project manager an automated email with a link to an update form to change any information regarding a project, is there a way to have a form be a standalone link in the intake sheet that when clicked opens up a form in a new tab. From there, the user…
