-
Show my "up next date" based on the child-parent task relationship?
Hi! I've been using the MIN and MAX children functions to roll up dates from child tasks, or sub-tasks, to the parent task. I also want to create a column that looks at the dates of each sub-tasks and grabs the one closest to today's date so I know the "next upcoming due date" among a parent's children/sub-tasks. What…
-
I'm getting an "Invalid Data Type" error
Hello, I'm trying to count all rows (using a cross-sheet reference) which have either "Discovery Call - Scheduling" or "Discovery Call - Scheduled" in the Sales Status column but am getting an "Invalid Data Type" error. Thanks you.
-
And, Or, NOT(isblank) Formula help needed
Hi, I'm attempting to write a formula that would check a box in a specific column if the [De-prioritized?[check if yes]] column is checked OR the [Date Marked Complete] Column is NOT blank and [Date Marked Complete] column has a date more 30 or more days in the past. Below is what I came up with, but am receiving a…
-
Calculating work hours %
I feel like this should be very simple but my math just isn't checking out. I have a duration column tracking how many weeks per task the work will take. I also have a "work hours" task that is tracking how many actual hours the work will take over that given duration. I'm trying to make it so my "Allocation" column…
-
Preserving Approval Date
I heard in an ENGAGE 2018 video on alerts is that you can set an alert to request approval based on the values of one of the cells in the row. You can choose a column with drop-down properties to indicate that the alert was Submitted, Declined or Approved. Someone at the session asked if there is a way to know the date of…
-
Average with multiple columns
I have a sheet that collects information about quality control scores. I have a column "Total Points" that I am looking to average; however, I am trying to use two different columns to base the average off of "Region" and "Quarter" so basically if the region= Southeast and the quarter =Q1 I want to get an average of Total…
-
Formatting A Sheet
Hi all! I am back again with another Smartsheet question! This time I'm not certain if what I'm asking for is even possible. I was wondering if it would be possible to format 3 columns to make them smaller and more digestible. At the moment, I have a sheet that displays dates tasks have been completed, the week of that…
-
Creating a count using COUNTIF across multiple columns
Hi, i would like to count the number of yes's in a column with a corresponding service line in a separate services column my first column has three drop down options yes/no/NA and i would like to be able to count each one So for example: M&E yes = 37 M&E No = 12 M&E NA = 2
-
Taking Weekly Average Every Friday.
Hi all! I have a spreadsheet, on this sheet I have some values I would like the average of as well as dates assigned to these values. Taking the average is not the only thing I need to do, I need to take the average of these values, grouped by week, from Friday to Thursday. Meaning I have to find a way to group the values…
-
COUNTIFS NOT ISBLANK from another sheet
Hello, I am trying to create a =COUNTIFS function, I know the it works up to the NOT ISBLANK part, I don't think I am off by much, but am not sure what I have wrong, can this please be looked at? Thank you so much! =COUNTIFS({Project}, $Project@row, {Status}, Completed$1, {Metrics & Production Dashboard Build End Date},…
