Formulas
Discussion List
- Hi, I have a dropdown list where people enter several answers manually and there're around 2,000 different legitimate answers . I have a different sheet that has all the correct answers. Is there a wa…
- 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…
- 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 fo…
- FORMULA 1-I need a formula that will "count 5" check boxes and a "contain" to either "check a box or a symbol."
- 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…
- 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, "…
- 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…
- 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 ES…
- 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 matc…
- 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 = …
