-
SUM by month
Hi guys, I'm trying to total income by month, and my formula is not working. Can someone please advise where I am going wrong? =SUMIFS({Fee}, {Date Received}, MONTH(@cell) = 10, {Date Received}, YEAR(@cell) = 2020) Where {Fee} is what I need to sum. I'm then trying to sum in November 2020 in the above example... Feel like…
-
Averaging numbers that meet a defined criteria
I'm creating a metrics sheet to feed a dashboard. On this sheet I am referencing a different sheet with the data. The formula I need to create would do the following: 1) AVERAGE the numerical values in one column. 2) IF the data was collected in a certain month, which is identified in a different column. So for example, I…
-
Regrouping Delimited Data
I pull data from an internal system and add it to Smartsheet via Data Uploader. When it comes in, it looks like the above, with Biz Entity, Sub Business Entity and Product Family grouped as delimited data. However, I want to regroup it so that each Biz Entity/Sub Business Entity/Product Family group is together in a single…
-
Formula modification help.
I need to modify a formula to pull values of two different cells "SAP PROJECT NUMBER" and "JOB NUMBER" from another "Time Tracking" sheet. I make it work with pulling just one lookup but not two. Below is my formula for one - where to I add the [JOB Number] so it pulls both in this formula? =SUMIFS({Time Tracking Range 4},…
-
Autopopulate Date based on contract renewal terms
Hello, I am looking for a formula that would help with calculating a date based on dates and criteria in two other columns. Here is the scenario: I have a contract with an expiration date. This contract is auto renewed for a certain number of years (3, 5, 7). I would like to create a column that contains a formula that…
-
Help with MAX Function
Hello, I need help writing a MAX formula to return information by the latest creation date. My current formula is =IFERROR(INDEX({CS PT Recruitment Candidate FirstName}, MATCH([Workday PID]@row, {CS PT Recruitment PID}, 0)), ""). If we recruit for a position multiple times in a fiscal year, the position ID remains the same…
-
Subject line of email notifications
Hi all, My team uses the chat feature in a shared spreadsheet. We receive email notifications from Smartsheet when someone has replied to a chat we're following, or if we get tagged in a chat. Is there any way to customize the subject line of the email notification? Thanks, Christina
-
I am trying to sum a column when the checkbox is checked, what is the formula for this? Thanks
I have a column named Spend and a Live column with a checkbox. When the checkbox is checked, I want to take the dollar amount from the Spend column and add total them
-
Can I include a date from another sheet into a formula for my current sheet?
Hello. I'm pretty new to Smartsheet and can't find an answer to today's dilemma. For example, I have a two sheets: ABC Project (belongs to me) and XYZ Project (belongs to our vendor) I want to be able to calculate a start date on one of my tasks in ABC Project by pulling a finish date from XYZ Project? Basically like this:…
-
Count between ranges
Reaching out to see if my formula, which seems to be working, is the correct way to COUNT between two ranges. In my example - I want to count a category name AND only if the % Complete range is between 25% - 49% FORMULA =COUNTIFS({Function}, "Asset Protection", {Percent}, >0.25, {Percent}, <=0.49) As mentioned this seems…
