-
Calculate Average for Duration Column
Hello, I have a column in a sheet that displays the duration for every project in our portfolio. I would like to calculate the average project length. When I use the AVG forumula, I get an error that says "# DIVIDE BY ZERO" Does anyone know how to get the average? Thanks!
-
Applying new template sheet to old projects
We have a collection of projects that were created some time ago. Since the projects were created, the blueprint those projects were based on have had some additional template sheets added. Is there a way to incorporate those new template sheets into the old projects, either on a single project by project basis or in bulk…
-
Adding all task participants to parent cell
WHAT I WANT TO DO: I need to add all participants of tasks to the tasks' parent cell (one time each, in case that's an issue). If there is a way to automate this, I would love to hear it. That's the long and short of it. WHY I WANT TO DO THIS: Why do I want to do this? Well, in an attempt to add parent rows to reports, but…
-
Text in Update Request splits in the middle of a sentence and moves to new row.
Hello: I have an Update Request that contains a message. For some reason, SmartSheet is causing a break in the text and moving a portion of a sentence to a new row. No matter what I do with it, I can't get it to flow the way it should in a paragraph. I even created a second Update Request, retyped of the verbiage and it…
-
Random Duplicate Records in Card View
Random duplicate records appear in Card View. Any ideas about what I'm doing wrong? Thanks.
-
Sum up rows within the VLOOKUP formula
Hi everyone! I have several projects in my time tracking sheet and would like to use the VLOOKUP formula to save only the times per project in a monthly cost table. For that I used the following formula: =VLOOKUP([Project Number]12, {Sheet - Time Tracker (10-October) Range 1}, 8, false). Unfortunately, I only got one labor…
-
Returning Task Name based on a MIN(COLLECT(range, criteria_range, criteria)) formula
I am trying to get the task name of the current milestone to populate a cell so I can use that cell in a dashboard. I have a helper column that counts the number of days until due, and can get the lowest number in the range that is >0, no problem. How can I return the Task Name of the row that I find my lowest number > 0?
-
Method/formula to rename sheets, reports and dashboards in a folder
Have a folder with 15 sheets, reports and dashboards used as a template folder. Titles include (Clear) as a generic placeholder in the folder and used in the 15. When a new project is started, we "Save As New" that folder, replace (Clear), with the project folder name and do so for each associated sheet, report and…
-
find and replace text in an already created update request.
I have update requests set for each employee's annual review. I would like to change one bit of text in the preformatted email. Is there a way to do this? Specifically, the line reads: Contact Mary Beth or Jesse. I would like to remove 'Mary Beth or' Is there a way to do this without opening each request individually and…
-
Generate reference after box ticking
Hi all, Been trying to look for my solution here, but i can't seem to find it. Hopefully someone can help me. I have a supplier approval database with supplier info, several checkboxes for required docs, etc. Also have an approval column, and then an approval reference column. What i intend to do is, when i tick the…