Trending in Formulas and Functions
-
Can you collect a rolling 4 of values in a row, rather than column?
I'm trying to get a rolling 4 (and rolling 13) average for these conversion metrics that I track weekly. Can I capture that data across a row, rather than within a column? Here's a screenshot of a basic average formula for the past 4 weeks. But what I'd like is for the average to automatically calculate the last 4 weeks…
-
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!