-
Reversing WEEKNUMBER Function
Hi all, I have a few values corresponding to different dates, and I would like to group these dates by their respective weeks. What I am thinking of doing is using the WEEKNUMBER function to generate what week they are in, and then grouping them using this number. Additionally however, I would like to group them by the…
-
Reference date above to carry on sequence when row moved
Hi Sorry to go into an old post but this is what I want, to look at the dates. I want to look at moving rows which have sequential dates based on planning. =WORKDAY([Online Date]248, 1, {Holidays Range 2}) I also want this to inherit from the date above to repopulate the sequence in order as shown Currently, if we move a…
-
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