Trending in Formulas and Functions
-
Count unique values from a separate sheet
Hello, SmartSheet newbie here with my first question for the community. We were able to build a working formula to count unique tickets in original sheet =COUNT(DISTINCT([Ticket #]:[Ticket #])) I then took the above formula to my metrics sheet and changed to reference another sheet value and the formula no longer worked…
-
Subtraction formula that is based on another formula
Hi everyone, Please send help. I have a formula set up to calculate total costs. However, I need to have it set up so that the total amount subtracts from a budget total. For example, say the budget it 20,000. I need the =SUM(Amount:Amount) to automatically subtract from the 20,000. I hope this makes sense. Thank you!
-
Multi Select HAS Formula
Hi I'm trying to get a sheet to count any projects where Finance Teams and / or Finance Systems are required to deliver a project at a particular status for a Portfolio dashboard metric. I'm currently using this formula but, it's not pulling the right info back - I'm getting a zero return when I'm expecting a number.…