-
Loan Amortization Formula
Good Day All: I need some help with my Loan Amortization Formula. I am trying to subtract out the Escrow from the Principal that is included in my payment. Current Formula Yields $1,771.06 which is incorrect. The correct amount is $322.85 if he Escrow is $1,448.21 per month =IF(Interest7 = "", "", Payment7 - Interest7 +…
-
Pulling from another sheet based on conditions
Hello everyone and thanks for any help you might be able to provide me, with my project. What I am trying to do is update a single sheet and have as much of that information populate another sheet as I can, but only if the customer is a certain one AND the "SFDC Category" = "Closed Won". Here is what the first part of my…
-
Formula in a cell that is within a range referenced by the formula
@Genevieve P & @Andrée Starå I was finally able to do some testing based on THIS THREAD and the recent discovery that you can reference a range in a formula that covers the cell that the formula itself is in. I got some interesting results when I used JOIN and JOIN/COLLECT. It treats the cell as blank, so if you just…
-
COLLECT criteria Date is NOT Blank
=COUNT(COLLECT({ContractPayments Range 3}, {ContractPayments Range 1}, Agreement@row)) Above formula works fine, but I want to add another criteria to it where I check if a Date column value exists. I tried below variations, but both do not yield correct answers. =COUNT(COLLECT({ContractPayments Range 3}, {ContractPayments…
-
Multi-dropdown sort order
Hello, I have read in a support article the following: "Values in Dropdown cells are ordered based on their order of appearance in the values list." However, does anyone suggest or know of a workaround in using a multi-dropdown menu, if you want to select a values to appear in a specific order and not have them auto…
-
Formula to return multiple contacts based on multi drop down options
Okay, I'm trying to write a formula to automatically populate a contact based off the information selected in a multi drop down. I have a separate sheet that lists the appropriate contact for each item (Sheet Name: HR Contact for Reminders). In the sheet "Seasonal, CDL, & Missing Requirements", I want the "HR Contacts for…
-
Lookup in one column to enter text in another
I want to look up a value from a dropdown in one column and enter text into another column based on the value found in the first column - is this possible? I can't seem to work it out! For example, if 'Column A' is '123', 'Column B' will populate with the text 'Great'. Again, if 'Column A' is '456', 'Column B' will…
-
Match Volunteers to Meetings
I need a way to match a list of volunteers to meetings in their area. Sheet A houses volunteer information, and the input is a Smartsheet form. Very basic, houses employee info and state (has multiple name columns because I added the "Name" column as a contact column while I was playing with formulas. Ultimately, it will…
-
Topic: Move Record Issue: Downstream Receiving Table Column Formulas will not stick on incom. recrd
Hi Team, I have move record functionality in my tables, and for some reason, the incoming records coming into my tables will not inherit the formulas on the columns... even when I have two template records hidden on each sheet which I need this to happen... the template records formula from the accepting table is EXACTLY…
-
Date Calculation: Subtract Days from Original Date
So, I'm a beginner in Smartsheets. I'm trying to build a sheet that has one "parent" date that the rest of the dates are "born" off of (e.g. T-27 days, T+14 days, etc.). I'd like to avoid using Duration because the start date isn't firm (but the end date is). I've been all over the community help section, but no matter…