-
Weekly Data Report Showing Trends by Month
We export data weekly showing the number of registrations for a variety of products. I have the data in a line graph showing the trend over time but the graph doesn't display the value of the date. Ideally, I would like to simply display the value of each month on my dashboard while retaining the data that is updated…
-
Summary Sheet Formula - Basic
In a financial sheet we have monthly totals. I would like to create a summary for each quarter. I am able to only include 2 months at a time. How can I include the total for Mar 2xxx? =SUM(([Jan 2xxx]:[Feb 2xxx])) I found this formula which gave me an Invalid Operation error =sum([Jan 2023]:[Jan 2023]) + ([Feb 2023]:[Feb…
-
Is a cell value driven cross sheet formula possible?
Our projects have a subfolder with any number of sheets that all have the same data layout. We need a summary sheet that fetches a status value from each child sheet, but i can't figure out how to do it in a way that wouldn't take 90 hours of tedious work - that would need to be repeated forever and ever In excel i'd use…
-
How to automatically update text every week?
Hello, So I have two columns: "Date Week Ending" that lists the last Saturday of each week and "Reference" that lists an X value. I want to have the X value appear for the PREVIOUS week ending date when my current week starts. For example, if today is 9/9 then I want the "X" value to appear for the week ending date of 9/7.…
-
Number of duplicates
Hello, I'm brand new to Smartsheets. Is there a way to find the number of duplicates in a column for a specific value? For example, how many "John Smiths" are in a list of names? Many thanks, Pltrmgrl
-
Time and Date Calculation
Back to SLA calculations, this calculation worked in the previous wave of Hypercare, but for some reason isn't doing so now. Background: We calculate SLA based on Priority Critical=4, High=8, Medium=24, Low=48. Actual SLA tracks how long a Ticket remains open. I know I am missing something. =IF([Tracking Status]@row =…
-
Need help using Countif while Referencing Another Sheet
I’m trying to simply count the number of times “A” appears in a column called "Severity Rank” on another sheet called “Master KPI Sheet” by using the following formula and it will not work. Can someone advise on correct syntax? =COUNTIF({Master KPI Sheet}!Severity Rank:Severity Rank, "A")
-
Moving Comments Between Sheets
I am looking to find a method to copy select columns in a row along with the row comments from one sheet to another. Methods that I have tried and will not work in this scenario: Copying the entire row from Sheet A to Sheet B (This brings over all columns and I am only looking to copy over select columns) Using helper…
-
Pulling in earliest start date from another sheet based on one criteria
Hi Smartsheets Community, I am trying to work on a formula that pulls in the earliest start date for a column (in another reference sheet) based on a criteria, which is the project type. The current formula I have is: =MIN(COLLECT([{Additional Items Target Start Date}]:[{Additional Items Target Start Date}], [{Additional…
-
COUNTIFS with OR
I am trying to create a function using COUNTIFS with an OR function and am struggling to find an answer to my issue. I've tried using the AI formula generator and have searched through here for answers but none have been successful. I need a formula that will flag rows that have the same value in column 1 and column 2 OR…
