-
Using a formula to Reference another sheet with two variables
I'm trying to create a formula for a report that references another sheet but it needs to reference and check two columns. My crude formula below to illustrate: =COUNTIF ((RefSheet1Range1)="Windows Server" AND (RefSheet1Range2){Status}="Completed") This would return a count of the number of Windows Servers that have been…
-
COUNTIFS, WITHIN DATE RANGE, ISBLANK FOR ADDITIONAL DATE RANGE
I need to write a formula for counting active projects that are past due for a current month based on schedule complete date being in that current month and when actual complete date is blank. Project Status = Active Schedule Complete Date = 7.1.20 - 7.31.20 Actual Complete Date = Blank Here is the data and fields I would…
-
SUMIFS to Calculate Values for a Specific Year/Date Range
I am trying to use SUMIFS with multiple criteria, and I am failing horribly. I seem to be having trouble when I try to add the criterion to sum data from a specific year (from a Date field) and/or when I attempt to add data from a date range. I have searched the community questions, and I haven't been successful in finding…
-
Combining Two Sheets into a Report
I have two task lists with slightly different columns, but there are some overlap - like status, completion date, & targeted completion date. I would like to run a report or some how combine all the tasks into one report/view/sheet - while continuing to maintain the two task list as separate sheets. I tried to create a…
-
How best to link 3 columns from a mastersheet to a secondary sheet.
Hello, I've had a colleague come to me with a query about how best to link 2 sheets. Her enquiry includes a handy diagram: I'm wondering if cell linking would be best bet here? I realise this would obviously require her to keep having to action this for the 3 columns in question, when a new row of data is entered but it…
-
Metric Widget - Multiple Cell Display
I am pulling data from multiple cells within a Project Sheet. The issue is that for each cell, the information is being presented differently. In some cells, the data is presented BELOW the Cell Title while in other cells, the data is presented NEXT TO the Cell Title. Is there a way to have the data presented the same for…
-
Automatically update current stage
Hi, I am trying to track progress through various stages of publication (the columns titled approval, data collection, analysis...accepted). I thought the health bubbles may be a good way to quickly visualize progress but it is confusing the card view as it can only organize per specified column at a time. What would be…
-
Find most recent updated status for category
Hi all, I'm searching for a solution on following idea: I have a sheet with following four columns: Created (date) | Category (Dropdown) | Previous Status (RYG balls) | Current Status (RYG balls) Now I want to auto-populate "Previous Status" with the last "Current Status" of the same "Category" when a new row is entered.…
-
How do I get the % to stay at 100% and not 150%?
How can I get the Completion Rate to only show 100% rather than 150%?
-
Smartsheet chart reneame "the source data for this chart has been changed"
Hi, Is there a way to reneame the error message Smartsheet charts show ("the source data for this chart has been changed") when there is no data in the underlying report it's being driven from? I have set up my charts in such a way that once data is added for the future months, those charts for the future months will also…
