-
Sumif with multiple assined to
We would like to create a list of all team members and the sum of their days on task for each team member, but we are having issue when there are multiple people assigned to one task. Each name should be only once in the list with the sum of the days. The result when summing up the table of our screenshot should be Rahul 7…
-
Training Plans - Central & Individual
Hello, I would like to build a central sheet that records training courses for my staff. These courses could be assigned to the group or to various individuals. What I would like is to have each individual to have their own training plan sheet, where they could add their own courses and track the courses I have assigned to…
-
Formula for date range
I am trying to calculate the total amount of invoices, from a given contractor, within a given date range. Im not sure how to write a formula to calculate within a specific date range. I have the formula to calculate the total invoices for an individual. But not sure how to insert date range into the formula. Here's where…
-
Using WEEKNUMBER() Formula
I'm trying to use the WEEKNUMBER() formula while calling a cell with a date in the format 07/17/19 and I keep getting an INVALID DATA TYPE error and I cannot figure out why. This is the formula in the cell: =WEEKNUMBER([Install Start Date]1) The [Install Start Date]1 displays 08/08/19 but is gathered from a VLOOKUP into…
-
If Function with Checkbox
I think this is simple formula - but can’t figure it out. I want a formula where if checkbox is checked, it puts the same amount as another extended column that I have. If checkbox 1, then take # from extended amount in same row and x1 in that cell. Does that make sense?
-
Does anyone have the formula syntax to control the RYG and Gray symbols on a sheet
Does anyone have the formula syntax for this.... to control the RYG and Gray symbols on a sheet? if due date < today and % complete <> 100% then red, if due date within 5 days of today and % complete <> 100% then yellow, if due date outside of 5 days from today % complete > 1 and < 100% then green, if % complete is 0 and…
-
Automate RYG Balls when checkbox is ticked in another column
Hello Smartsheet Experts! Can someone show me a formula to use to automate the RYG balls in one column when a checkbox is ticked in another column? Green if checkbox is ticked and Yellow if checkbox is not ticked? Thanks so much for any assistance. ~Cecelia
-
Populate date fields per status changes
Hi, I am running into an issue with populating date fields per status change. I have two date fields that reflect per status change. For example: If status change to "option 1" change this date field to today's date. If status should change to option 2 change second date field to today's date. What I have currently:…
-
sumif parent row
I'm looking to find the the sumif of current week for a specific matter. However the matter is only listed in the parent row =SUMIFS({Test Hours}, {Week Number}, @cell = (WEEKNUMBER(TODAY())), {Matter}, =PARENT({Matter}@row) I keep getting an error in the formula
-
Counts with status and Date
Hi, I'm new to Smartsheet and I'm having some issues with one of my formulas. I want to get a count of everything where the Status = Completed and then the following: * Due Date = Completed Date * Due Date > Completed Date * Due Date < Completed Date