-
Merged: Changing Cell Value based on Cell with a Cross-Sheet Formula
This discussion has been merged.
-
Using COUNIFS to find a partial text match in 1 cell + if another cell is filled/blank/specific text
Hi SmartSheet Community, We've created a data set that is now being utilised by stakeholders, and we are trying to set up a way in which we can monitor the completion progress. The intention is to show each stakeholder their progress via our shared dashboard Description of our desired formula; Count if "X text" appears in…
-
Auto generate project number using formula
Hi, I'm trying to create a formula that will auto populate the project number when a new project is created through a form. When a project is added through a form it appears at the top of the sheet. Our project numbering system is YY-XXX where YY is the year of the start date of the project and XXX is the project number…
-
Refrencing cells and rows with formulas
Hello, I need to refrence cells from "Sheet 1" in "Sheet 2". I have made few columns in "Sheet 2" and in each of them, in the first row, I have the formula: =INDEX({Sheet 1 Range 1}; 1) Each column has it's own range, but I have to prefill the next 200 rows and I can't just write manually "; 2", "; 3" in each one. It's sad…
-
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…
