-
Stuck on completed in the last 7 days formula / function
Hi I keep getting incorrect augmentation for this cross sheet formula =COUNTIF({Sheet 1 Execution completed}, =TODAY(-7), +COUNTIF({sheet 2 execution completed date}, =TODAY(-7))). When I out <= Today(-7) I got numbers that did not exist. I am new to smartsheet and trying to learn via youtube and here. Many thanks in…
-
Convert Numbers (Days) to To Year/Month
I'm trying to convert number of days to year and month. In excel I would use the following formula =DATEDIF(0,[Days closed]11,"y") &" years, "&DATEDIF(0,[Days closed]11,"ym") &" months" Though this formula does not work in smartsheet is there another way to do this
-
COUNTIF/AND/THEN CHECK A BOX OR SYMBOL
FORMULA 1-I need a formula that will "count 5" check boxes and a "contain" to either "check a box or a symbol."
-
Average if when date is current year
we want to update the formula to show the average # of problem solving days when the idea is a JDI and the opportunity was submitted in the current year. Current formula - missing component to reflect only submissions from current year. =AVERAGEIF({APD CI Tracker Range 5}, ="JDI", {APD CI Tracker Range 4}) {APD CI Tracker…
-
Need to add on if "Yes" leave blank to my formula but cannot get it to work
Hi, I have been assigned smartsheets and am trying my best to train myself via youtube + the forum. I created this formula =IF(ISBLANK([Completed Date]@row), "", IF([Completed Date]@row > [END]@row, "No", "Yes") It shows if the completed date is blank: leave blank if the completed date is greater than the end date put no…
-
Formula to see if completed date is within the last seven days of the final acceptable date
Hi, I have a due date (which is a guidance), and then a final acceptable date. I would like to see what items are completed on the last 7 days (including the last day) of the final acceptable date. If it is completed in the last 7 days of the final acceptable date it will be "yes" , otherwise blank. Any help would be…
-
Summing values
Folks, I am looking for some help here. I am trying to calculate a value when the following conditions are met: If Billable = "Yes" AND Sprint = "Sprint 01" THEN SUM VALUE(Cell different sheet)/SUM ESTIMATES (this sheet where above conditions are true)*ESTIMATES value this row I have played around with multiple different…
-
COMBINE FORMULA TO LOOK UP 2 DIFF SHEETS
I need formula that will look at 2 sheets with different criteria but return field ops when a match is made. Sheet A might not have a match but sheet B does... and vice versa or Both sheets has a match and I need the " field ops to return in 1 column =IF(COUNTIF({Field Ops Invoice Tracker Invoice}, [Invoice No.]@row) > 1,…
-
Red, Yellow, Green, Gray automation formula help needed for numerical ranges
I have a column called "Resource Totals" and I am trying to create conditions for the status column (Already made it a symbols column) for Red, Yellow, and Green Green = 0.9-1.1 Yellow= 1.2-1.3 Red = >1.3 =IF([Resource Totals]@row = "0.9-1.1", "Green", IF([Resource Totals]@row = "1.2-1.3", "Yellow", IF([Resource…
-
Formula not working
Hello, can you explain this error to me? The formula returns me the value 0 for a project that lasts one day Thank you