-
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
-
RYG Formula
Good Day All: I am trying to add to my formula so that if the Due Date (Actual) is Blank/Empty, the RYG is Blank/Empty. My existing formula: =IF([Due Date (Actual)]3 > [Due Date (Planned)]3, "Red", IF([Due Date (Actual)]3 < [Due Date (Planned)]3, "Green", IF([Due Date (Actual)]3 = [Due Date (Planned)]3, "Blue"))) Thanks
-
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!
-
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:…
-
Creating a Formula for Dates and Traffic Lights
Hi, all! Our office is new to the SmartSheet community. I am having some trouble creating a formula for a sheet. I have the following columns: * "Initial Contact" - formatted as a date * "30 Days Since Contact" - formatted as a green traffic light * "60 Days Since Contact" - formatted as a yellow traffic light * "90 Days…
-
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…
-
Nested IF statement is giving me an UNPARSEABLE error
Hi, I'm using this formula: =IF(COUNTIF([Pilot Status]10:[Pilot Status]12, "No") > 0, "No",IF(COUNTIF([Pilot Status]10:[Pilot Status]12,"Hold")>0,"Hold","Yes"))) to show a "No" Symbol if there is at least 1 "No" in the range, if there are zero "No" in the range, then i want it to show a "Hold" symbol if there is at least 1…
-
How do i get symbols to appear instead of the word representing a symbol?
Hi, I am attempting to write an IF statement with the result being that the "Pilot Status" cell will have one of the symbols in it. I have formatted the field to show symbols, and I've written the formula to use the representative words, but i'm still only seeing the word show up in the field. HELP My Formula…
-
How can I get the number of checkboxes checked in a single column ?
Hello, I'm trying to get the number of checkboxes that are checked in a given column (more precisely, A10 - Transcode colum) without using another column to do so (in this case, Valeur A10 - Transcode column which displays ''1'' when a box is checked and ''0'' when it's not the case). As you can see in the screenshots, I…
-
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…
