-
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
-
Subtracting date and time
I am working on a delivery smartsheet, where I need to figure out how long it takes to get a product from the order phase, to the parts picked to the delivered phase. Here is a screenshot of how our times are formatted, these can be over multiple days and not just a single 24 hour period. I looked through other posts to…