-
Column deduction formula
Hello everyone Im trying to add Deduction col to my formula in screenshot/below: =(IF([📈 Monthly Target]@row <= 600, [📈 Monthly Target]@row * 0.15, 90 + (([📈 Monthly Target]@row - 600) * 0.25))) + 40 + Bonus@row I need the value amount in (Deduction) column to be deducted from total formula amount ( in Est/Salary) I tried…
-
Average between two date columns based on a specific condition
I want to calculate the average days between two date columns for a specific status (ABC). I have a column for the average days named: "Avg Days (Req to Sent)" and this is my formula =IF([Type]@row = "ABC", [Sent Date]@row - [Requested Date]@row, "Not ABC") This works. Now I want to calculate the average days from this…
-
Finding a "." in a cell has me perplexed with an "!"
Okay, bad pun, sorry. It's been a rough search today. I have an ID field for tracking Risks across projects. Each risk has a whole number: 1, 2, 15, 22, etc. Each mitigation is a sub-number of the risk: 1.1, 1.1.1, 1.1.2, 15.1, 15.2, etc. It isn't easy grouping them together, and auto-number to do this, so I wanted to have…
-
Finding a "." in a cell has me perplexed with an "!"
Okay, bad pun, sorry. It's been a rough search today. I have an ID field for tracking Risks across projects. Each risk has a whole number: 1, 2, 15, 22, etc. Each mitigation is a sub-number of the risk: 1.1, 1.1.1, 1.1.2, 15.1, 15.2, etc. It isn't easy grouping them together, and auto-number to do this, so I wanted to have…
-
Summing corresponding values from a multiple drop down with more than 1 entry possible
I have a reference sheet of food items (column 1) with corresponding prices (column 2): potatoe - 3 milk - 5 onion - 1 Cheese - 2 On another sheet, I want to sum the total applicable from a multiple selection drop down cell. for example: If potatoe, milk, and onion were all selected within one row, my formula would return…
-
Conditional Formating based on recent changes
Hello! I tried to find if it is already covered with no success. Highlighting tool is very useful, but has some limitations. The case is the following: We are using Smartsheet project sheets to manage our Product Developments. Very often, our PMs have to run some scenarios to test how certain changes affect the project &…
-
Can you link 2 lines by clicking on them?
Hello, I'm trying to replace an Access database with Smartsheet. This would be tracking the company's overages and shortages. I have an overs sheet and a shorts sheet. I have a form to add new entries for each. I have a report to show what it still currently open. I have a dashboard for visuals. But what I need to be able…
-
Return 1st, 2nd, and 3rd non-blank value per row
Essentially, I want to create a Master_Supervisor_List and Master_Employee_List. Essentialy my columns go from "Supervisor AH" all the way to "Business Title ZH". I cannot reorganize the columns because the survey is built using logic. The columns repeat in the following order: Supervisor, Employees, Buisness Title. In…
-
Does INDEX(MATCH) work on a WBS column with WBS values generated by a formula?
Hello, I have created a project schedule template for my team, with tasks, subtasks and associated timelines on one sheet. I have a second sheet where I am creating a procurement template to track our project materials. I would like the procurement template to pull the task name and target date from the project schedule by…
-
Fuzzy Match in Smartsheet?
I'm wondering if anyone has developed a way to compare two text strings and return a similarity score? I know that Microsoft Excel/Power Query can do this, but I want to try to accomplish this in smartsheet and I haven't found discussion threads thus far. My use case is matching fuzzy data, for example "Google, Inc." would…