-
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…
-
Other than Sheet Activity Log and cell activity, can I tell what something has been changed from?
I have a Smartsheet where there are dates I have put in and I want to see what it's changed from after I've made a change. I know I can look at the sheet activity or look at individual cell activity, however, I want to see those dates side by side. I need to be able to show what I have scheduled for something and then what…
