-
Last Modified data in Sheet Summary?
I'd like to be able to create a sheet summary report for all of the sheets in a workspace, showing their last modified dates. This is to help me gauge when a workspace is no longer needed or to keep an eye on updates at a high level without going into multiple sheets. My idea was to add "modified date" into the sheet…
-
Auto Populating Columns
Hello, I populated the Risk Columns and Task Health Column in this example manually. Is there a way to accomplish this automatically based on the Internal/External Column, Due Date and Status Columns? Additionally, is there a way to remove the Risk flags from the header row in green? For instance: If I select "Complete" in…
-
Best method for linking 2 sets of data together that use forms to collate the information?
I'm working on a project to help devise a solution to track all of our organisation's skills & talent initiatives, plus that will provide us with some useful metrics. The plan is have 2 forms - part 1 that collates all of the schemes' information and then a part 2 that collates information on outputs, but which is sent…
-
Auto Save / Invalid Operations Error.
Hi All, I have been searching community forum to this unsaved issue that I am having with my PMO but no luck so far and appreciate if someone could help me with this. According to what I have observed, the tasks sheet is not getting saved due to which some of the columns on Portfolio / Project Tracking Dashboard (Schedule…
-
Reverse the Ranking Order
I am working on ranking clients based on revenue with the highest revenue being number 1. In the end I want to build a top 25 list that could change on any given day based on new data. I used this formula to rank my items: =RANKEQ([Lost Client-SUM-BI Estimated Annual Revenue]@row, [Lost Client-SUM-BI Estimated Annual…
-
Incorrect Argument Set
It seems I have problems with the SUMIFS formula. Tried replicating one that works and that was a no go. =SUMIFS({031-Purchase Order - Completed}, "Completed", {031-Purchase Order - Amount}, {031-Purchase Order - Year}, 2025) I want to sum together completed invoices by year. Thank you in advance. Ali
-
SUMIF and NOT Functions
I am working with three formulas to collect data in the Summary. I want to add the NOT Function to these formulas to exclude the rows that are starred in the CCC column. =SUMIF({Region}, "Philadelphia", {Contracted}) =SUMIF({Region}, "Philadelphia", {07/09/25}) =SUMIF({Region}, "Philadelphia", {Difference}) Thank you
-
How can I create 2 sheets in 1
I am trying to figure out how I can basically put a divider in my spreadsheet so I do not have to keep sliding the slide bar back in forth for the entire screen and just want to do half. For example, i want to be able to keep the first 6 columns on the screen and just slide the remaining columns to the right of the first 6.
-
COUNTIF Formula in Multiple Dropdown Box but Exclude a Word
I’m trying to create a COUNTIF from a multiple drop down column (referencing another sheet). Two words are similar: Active and Inactive. If I use CONTAINS, it counts both Active and Inactive: =COUNTIF({Certified Roster Range 1}, CONTAINS("Active", @cell)) If I use HAS, it counts when Active is the ONLY item listed in the…
-
Verification with Multiple Cells
Hi! I'm not sure this is even a thing, but I'm newish to Smartsheet so figured it couldn't hurt to ask. I pull transaction reports from our accounting system, and need to verify that the person who made the purchase used the correct ID. Here's an example. I need to verify that the name in the Employee Name column matches…