-
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…
-
Count days from Start Date enetered and stop count when Finish Date is entered
Good day, If someone could please assist. I'm looking for a formula that counts my "wayleave" days starting from since the "wayleaves have been submitted, and stops the count as soon as the Actual Finish date is entered for the "Wayleave". Ps. Should also be "NETWORKDAYS". Example Columns: Column "ROW 1 Actual Start": Date…
-
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…