-
COUNTIFs for Dates
I'd like to create a formula which only counts the Rows in which a date in a particular column is in the last 30 days (among other criteria) =COUNTIFS({Referral Source}, "Elm", {Database Status}, "Green", {Database Date of Referral}, <TODAY(-30)) The section in Italics is the area I am trying to sort out. Thanks in advance…
-
Returning Task Name based on a minimum number in Helper that is >0
I have previously asked a similar question, but with fewer requirements. I am trying to return the Task Name associated with the lowest number in a helper column that is >0. With some help from L@123, I was able to get close, I think, except the following code returns a zero, and there are no zeros in CHILDREN([Task…
-
why does smartsheets not Sum Cells with leading zero values
I am trying to do a =SUMIF into a sheet via cross reference (=SUMIF({Mth/Yr}, ={Prev Yr Mth/Yr}, {DofC NN.NN})) Mth/Yr = 9-2019 Prev Yr Mth/Yr = 9/2019 DofC NN.NN contains rows that have a value with 0.nn (nn = 01 thru 99) The result from the SUMIF is 0 (zero) Does SS not add values with leading zeros? What am I doing…
-
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?