-
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!
-
INDEX, MATCH, AND formula
I am trying to create an Index / Match cross-sheet formula if two cross-sheet criteria are met. Sheet One displays the Sales Reps for New and Modified Items: I want to display the Item Rep for NEW item types. The formula entered on Sheet Two is: =IF(AND(MATCH(Item1, {SHEET ONE_ITEM}, 0), MATCH("NEW", {SHEET ONE_ITEM…
-
Reference a date based on Percentage complete
In Sheet One, there are 25 products assigned to 4 Product Types. Each Product has an expected delivery and an actual delivery date. In Sheet Two, we want to add the dates associated with the percentage complete. The existing formulas provide the percentages and totals but how can I add the dates for the milestones. For…
-
custom email message
Hello, can we have a customized e-mail message while we share the smartsheet with the collaborators? Thanks, Bishwo
-
Feature Request: timestamp() function
It would be great if there was a way to timestamp the value of a cell. To enter the exact date that an event occurred. Several people have volunteered a modified date column, but something like the following functionality in an if-statement would be really great. =IF(FieldName1 = "blah", timestamp())
-
Summary Fields: Percentage of Completed Checkboxes
I'm very new to Smartsheet and hoping someone can help me. I have created a checklist, with different categories divided up by parent rows, and the tasks listed as children under the categories. I have a checkbox column and each task (in the children rows) has a checkbox. I have figured out how to calculate the percentage…
-
Export Entire Folder to pdf and include gantt charts
Hello, I like how the feature to export an individual sheet to a pdf view gantt chart view. However, if you try to export several sheets from one folder, the gantt charts will not show. I would like the ability to export all sheets into one document that will display gantt information. Thanks in advance on possible…
-
Publishing only filtered list to google calendar
I'm having an issues with "Publish to Googgle Calendar". Every time I've publish some task in google from SamrtSheet, SmartSheet publishes everything in my Google calendar instead of publishing the specific tasks assigned to me. I've attached a detailed description of the issue I'm facing with screenshots. Does anyone know…
-
Apply Formula to Entire Column
I'm trying to automatically apply a formula to an entire column that concatenates info from cells in a given row into a document name, once data is entered into those cells. The only way I've been able to accomplish this so far is to just copy/ paste or drag the formula as data is entered in a new row, but I'd like it to…
-
Form Feed to one row?
Is it possible to have multiple forms for a SS populate to the same row if the same text is used in the primary column? I have a sequence of tasks that will be completed over multiple days. Each task has its own form. Or, will the form populate to a new row upon completion? If latter, I suppose the solution is to create a…