-
Duplicate rows
Hello. I need to create a sheet that will store committee names that will continuously be updated and needing to be approved by multiple colleagues. Every time I need to have the committee names approved, I would like to be able to dump the entire list that originates from a different source into smartsheets, including the…
-
Date Grouping for Gantt Dashboard
Hi Everyone, I'm trying to automate a sheet into a Gantt Dashboard, however I am having issues finding a work around to show the child and parent dates, as all the information is stored in one row, rather than 3 rows for example. Sample Column Names: Project Name, Task 1 Start Date, Task 1 End Date, Task 2 Start Date, Task…
-
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