-
populate value within the same ID number with multiple criteria
Hi, I'm trying to create a formula that will populate Column Outcome (example highlighted in red). Within the same ID#, it'll populate the assignee based on: 1.) Within the same ID #, if column 5 has a %, and the assignee is not Sam, it'll populate the assignee name within that ID # 2.) If it's Sam, then it'll look at…
-
Internal Rate of Return Formula
Smartsheet leverages quite a number of formulas from Excel but does not use IRR (Internal Rate of Return). Would like to see IRR used in Smartsheet so that we can incorporate our Return on Investment spreadsheet in Smartsheet. Tyrell
-
collecting live information on a specific date
Hello community, I have a drop down column with stock status. It changes almost daily ; I need help creating a formula to count each status on the last day of the month (it could be the first if it's easier, 30th vs 31st as opposed to 1st). How do I do that? I know how to create the formula to count but sometimes I'm too…
-
Pull multiple IF THEN statements from data sheet?
I have a data sheet with 4 Columns that I'd like to pull into a second. In this simplified example, the Data sheet shows phase, activities which repeat for each phase and a date. I also have a column with "Yes/No" if I need the date in the Smartsheet. What formula do I use to get the data to my second layout? I'd like it…
-
Flags using IF AND formula with multiple sheets
Hello, I would like to create a formula where it flags for the following information: Donor Center = other sheet column Donor Center AND Job Title = Ops Admin QAS AND other sheet column Position = Quality Assurance Supervisor Then Donor center = other sheet column Donor Center AND Job Title = Ops Admin Assistant Mgr AND…
-
I am having trouble using "And", "OR" & "Countif(s)" to build a formula.
Hello, I am attempting to come up with a sheet summary formula that counts cells if they meet at least one of 3 different statuses in the same column, AND also meet one of 5 different statuses in a separate column. So using the screenshot I've provided as an example (although it doesn't have 5 different statuses in the…
-
Help with date calculation formula
Hello, I'm trying to find a formula that will help me calculate how long an intake took to resolve. The rows I need to be calculated are Date Reported & Resolution Date. If the resolution date is blank I want it to use the current date in the calculation to see how long this issue has gone unresolved. Any help is much…
-
JOIN() Formula Result - Producing Apostrophe in Copied Cell Data
The issue involves the usage of the JOIN() formula within SmartSheet, which is resulting in the inclusion of an unwanted apostrophe when the formula's output is copied to another sheet. The JOIN() function is designed to concatenate values, but in this scenario, the copied data is displaying an apostrophe that is not…
-
Combining Not Contains and Contains into the same formula
hi Team, The below formula. I am trying to combine these validations into one statement. If any of them are true, the row should flag as yellow. If any of them are false, it should flag as green. However, the statement is flagging as "green" when "warning records" is not found. It should flag as yellow.…
-
Searching with INDEX(MATCH(
Hello, I am working on building a portfolio level sheet that can operate as a searching tool within Smarthsheets and I'm looking for a little assistance to create a method to find based on key words rather than exact matches. Is this possible? What would the returns look like if there were multiple values? Also the below…
