-
Different Renewal Dates in Each Row
Hi I am trying to add a formula to add months to a date but each row are different months, I would enter the last renewed date and then the next column would auto update. For example I have used this formula =([Last Renewed]@row + 365) but this uses the same formula of the whole column also this is using days and not…
-
Disable Dependencies - Use weighed Formula on % Complete
Good Evening I am wondering if something could possibly tell me what is wrong with the following. I need to disable dependencies on my Network Project Plan. I met with the pro desk, and we test using the following formula and helper column. It appeared to be working but I think we might have tested it with dependencies…
-
Count Formula Help
I'm new to formulas and referencing other sheets in SmartSheet and need help with the following scenario: We are wanting to reference another sheet to sum the number of days a team member is absent in a period of time. The referencing sheet has the columns of [Date Absent] and [Team Member]. The sheet where the formulas…
-
Absolute Reference Changing
Hi Guys, I'm having an issue with an absolute reference changing, I submitted a support ticket, but I wanted to ask here as well So I have a sheet that is submitted to via form adding rows to the top. The operator puts values in the form, and formulas return RGB if the values are good. I want to pull all the "Red" values…
-
Finding Distinct Values from two different Sheets
Hello, I have a scenario where I'd been successful in summarizing the distinct users names who'd created entries in my sheet and done some calculations from that. Below is my formula: =IFERROR(INDEX(DISTINCT({NCP Originator}), Index@row), "") Now, my records have gotten to a point where I needed to archive older records,…
-
Multiple IF statements formula help
I am tracking completion of trainings by participants in our organizations using the Symbols fields and I would like to have one column that tells me if each participant has completed at least 1 training. I am trying to do this by using a formula with multiple IF statements but I keep getting an Incorrect Argument Set…
-
RANKEQ showing multiple 1 Ranks but still showing a rank of 2
I'm running into an issue using RANKEQ to determine the top 10 categories with some criteria while working with census data. The formula I'm using is: =IFERROR(RANKEQ([Speak English less than "Very Well"]@row, COLLECT([Speak English less than "Very Well"]:[Speak English less than "Very Well"], County:County, =County@row,…
-
Sheet Summary box COUNTIFS + AND/OR
I am trying to do something similar on the summary of a sheet.... I want to count if proposed start date column is less than or equal to today, as well as if the PC 2 column = one of "S1", "S2", "S3","S4","S5","S6","S7","S8","S9". I attempted by just trying "S1","S2","S3".... =COUNTIFS([Proposed Start Date]:[Proposed Start…
-
Countifs And/Ors
I am trying to count a specific series: Region1 + StatusComplete + Month series =COUNTIFS({Central HUB – 2019 Range 1}, [Primary Column]@row, {Central HUB – 2019 Range 3}, AND(OR(@cell = "2020-01")), {Central HUB – 2019 Range 3}, AND(OR(@cell = "2020-02"))) Formula only works with 1 Month, once I add the second month, it…
-
Counting Past Due Task excluding marked complete
Hi! Is there a way to count all tasks that are past due based off of date, but exclude tasks that are marked complete? =COUNTIF(Finish:Finish, <TODAY()) Can I add an exemption in this so marked complete is not counted? Please let me know! Branden