-
Help with COUNTIFS Formula
I'd like to count if the priority = high and the status = final version In other words, what is the total number of rows that equal both high priority and final version?
-
How to "actualize" or transfer dependencies of a completed task?
Task A Task B is dependent on Task A Task C is dependent on Task B For some reason, I was able to finish Task B and Task A was getting delayed. How do I: 1. Extend duration of Task A without impacting dates, duration or status of Task B? 2. Mark Task B complete, such that actual completion dates do not change irrespective…
-
Sum all Rows
My sheet has 3 columns (Team, Activity, Amount). I have a summary section at the top of my sheet where I want to use a SUMIF function to total up the amount for each Team. Generally, I can get the SUMIF function to work just fine. But, I run into an issue when adding new rows. The function looks like this:…
-
Is there a way to have a column automatically pull data from multiple columns based on the month/yea
I have a master sheet that includes data for multiple projects from different months. I'm trying to generate a column that pulls the data from the current month. The intent is to create a cell that populates automatically and can be referenced on a dashboard. I have tried to use the index/match formula with no success. I…
-
Formula Assistance
Hi All A newbie to Smartsheets, so please bear with me. I have a formula that works on excel but not on Smartsheets….any ideas why? Excel: =IF(K44="Approved",SUM(F43-C44),IF(K44="Declined",F43)) Smartsheets: =if([Approver approval]43="Approved",sum([Days Remaining]42-[Annual Leave]43,if([Approver…
-
COUNTIFS Using multiple ranges and OR statements
Im looking to count the number of times specific ranges happen from 2 separate columns. Essentially, I want to count number of issues open by Priority, excluding 3 different status types. Current formula only excluding "Resolved" =COUNTIFS({Priority}, "1 - Critical", {Status}, <>"Resolved") Need formula to exclude multiple…
-
COUNTIFS with more than 2 criterion
Hi, I am trying to do a count for a field with 3 criteria. I want to do COUNTIFS( A = "x", B = "y", and C = "Z"). Is there a way to achieve this as COUNTIFS only allows you to do this with 2 criterion?
-
Formula referencing data is returning off by 1 week
Hey there, I'm currently using the below formula to pull in and report the availability of our consultants on a per week basis. The formula sits in a Smartsheet that references another Smartsheet where the data is in two columns from a start date to an end date every week that Consultant is booked. The Smartsheet utilizing…
-
Date Modified - Copy of column creates different date
Hello, I am working to create an automation off of the date modified field. This is to alert users if they have not updated a row in more than 4 days. Since the date modified field is not recognized as a date field I created a copy of the column using the basic formula: =[Last Modfied]1 My results are not what I would…
-
Report not Matching Formula Issue
Hi, I have created a report to use on a dashboard for showing the number of job cards to print for our workshop. The report is shown below, and you can see that there are different amount of jobs to be printed for each workshop: You will see on here that there is: * 3x for the FASTRACK Workshop * 10x for the Van Workshop *…
