-
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…
-
Help with Bulky Formulas/Formatting?
Hi all, I'm fairly new to smartsheet (with no Excel experience either). Here's my situation. I'm tracking POs-- first, you enter in a PO amount, and in subsequent columns what you invoice per-month. There's a final "Totals" column that sums up your monthly invoices. Currently, I have a hidden column set up to test if PO…
-
Formula for Countdown
Hi, I've read through a few threads and I am unable to re-create a simple countdown formula. I keep getting an #INVALID OPERATION error. Am I missing something? Please help! Thank you!
-
Formula calculating revenue for Q2
I am trying to calculate revenue for Q2 only for a given property Here's what i had in the cell =SUMIFS({Garden Grove Bill Rate}, {Garden Grove Inv Date}, YEAR(@cell) = YEAR(TODAY()), {Garden Grove Inv Date}, MONTH(@cell) > 3). But that formula doesnt work now that we are in july. as it calculates july revenue as well. So…
-
Totaling percentages linked from another sheet
I am simply trying to get an average percentage in a parent row from children rows that are linked in from another sheet. Is the fact they are linked what is causing my error? Currently I'm just using: =AVG(CHILDREN())