-
sum the revenue by every 3 months?
I need to sum the revenue by every 3 months and want this to be automatically updated in the dashboard. For instance, if It's august I need to see the revenue of May + June + July. When august ends need to see the sum of June + July + August and how to do this. Can anyone please help?
-
Referencing another sheet, add totals in a column if meeting a certain criteria in another column
Hi, I don't know which formula to use, please help. I've got a sheet called "Position Requisition" with "TA Number To Offer" and "Location" column. In another sheet called "Dashboard Data" I want reference back to "Position Requisition" sheet to add the numbers/totals in the "TA Number To Offer" column but it must match…
-
Comparing current date with start date on project plan
I need to know if the start date for a task on a separate worksheet is in the past. That should be super easy. Compare Today() to the start date value on the other sheet. (I would type the formula, but it won't let me type the greater than and equals signs). I get an error #DATE EXPECTED. I tried with the column set to…
-
Changing a sheet formula to a sheet summary formula
I am working on a donor management tool and am looking to count the number of donors previously identified as "lapsed donors" who are no longer in lapsed status. I have created this formula within a column in SmartSheet. It correctly calculates the status of Lapsed Donor change (+1 for new lapse, 0 for no change, -1 for no…
-
How to count cells with BLANK value in a column
Say that I want to count how many cells with BLANK in a column? The column have many NOT BLANK values also. eg. ([Col]2 with BLANK value) Col row_1 a row_2 row_3 a .... row_n a so the column has 1 cell with BLANK, the count will be 1. How to write a formula to get the count? Thanks!
-
Count if & Unique Values?
Hi! I am struggling to figure out the logic required to count the number of monthly/quarterly/bi-annual/annual items without counting duplicates. Hoping to determine the number of updates on X frequency without counting duplicates. For example, there are 10 different monthly performance emails but they have been updated 10…
-
How to subtract a Month and Year from a Joined column?
Hello, What I need to do is subtract 1 month and for the corresponding year to adjust. In 1 column called App Window I have the formula to join two other columns. =JOIN([App Month]@row + ", " + [App Year]@row) In the next column, all I would need to do is go back 1 month. For example: January, 2023 -> December, 2022 or…
-
Do I have to enable a feature to use collect function?
Hello, I am attempting to use the collect function but when I use it with join, my formula bar does not recognize the collect. I try searching for the function within smartsheet and it does not populate. I can see all the help for join, etc but nothing for collect. When I use join(collect or avg(collect) the collect…
-
COUNTIFS with HAS Referencing Another Sheet
Good morning, Community! I'm struggling with a formula and could use some help. On the **CBO CBA Case Tracker sheet, the Priority populations served column is a multi-select with 21 options. The Priority Populations Served sheet has a Population column with each of the 21 values as I thought it would be easier to…
-
When Phases are Changed, Capture the Date:Workflow is not possible because the column contains links
Hi We have created one more test case. The sheet contains an AppliedPRO column in which these cells are linked to their respective individual projects. When the user changes the phase (Initiate, 1st DOE, 2nd DOE, Target Met), our source sheet (master sheet) will update, but I need a record date (capture the date) when the…
