-
Calculate Overdue Documents
I have two dates columns. One is Target Completion Date and the other New Target Date. I have the following two questions: I wanted to know how many documents did not meet the Target Completion date. Total counts. If the Target Completion Date was extended then how many documents missed the New Target Dates. Total counts.…
-
Sheet Summary formula IF AND
Hi, I'm looking for a formula for my Sheet Summary that will count the instances of checks in a checkbox column (CD), but only if the Status column does not show Complete. I've made a start with this, but it's #unparseable. =COUNTIF(AND(CD:CD, "1", [Status, "Complete") Many thanks!
-
#Invalid data type - Countifs on two category's.
Hi, team. Difficulty in nailing the formula.. Sourcing data from our Design sheet I'm trying to count for each of our sales team members how many requests they have lodged (10 requests types) & of those how many of them are at each status (7 types). IE, I could have 10 at Drawing only& of those 4 at "In Progress", 2 at…
-
The Real 0.00
Okay, I need the Smartsheet Community again.....I am having difficultly in figuring this out and thought that maybe you might be able to help me get over the “hurdle” with this one. I have several columns Variance $2.98 CTD_WD_0056 CALC (HELPER)] -$2.98 The problem is the extra decimal places, as I am bringing the data in…
-
Dynamic Formula Change to Date Function
Hello, I have a list of "Created Dates" and I'm trying to pull the appropriate "Created Date" into each Week and under its Day of the Week in a more efficient way. So far I have used "=COUNTIF([Created Date]:[Created Date], =DATE(2020, 3, 1))" to find 1 item for the Week of 3/1/2020 on Sunday specifically. As well as using…
-
SUMIFS not Working
Trying to SUM total from sheet 2 (column titled Grand total...)when the Job No column from Sheet 2 shown below matches the Job No column from Sheet 1(shown below) SHEET 2 SHEET 1 Here's formula - but keeps returning 0? =SUMIFS({Job Cost Original Budget Close-out Data Range 1}, {Job Cost Original Budget Close-out Data Range…
-
How do you Sum a Column for multiple same date entries
I have the following sheet (tracker) that I am trying to total or sum if there are multiple entries for one day. Do you have any suggestions on formulas to use? So for the below, I am hoping to get 1 daily total for 7/14/20. I have tried to create a summary sheet and reference the data from this sheet but I cannot get the…
-
Is there a way to catch duplicates?
Hello, I have created a bid list for my Salesman to let us know which jobs they are bidding. I created a form for them to do this. The problem I am running into is if the Salesman are bidding the same job. I have a Row called Job Name. Is there a way to flag duplicates for the same job name? Thanks!
-
Help - SUMIFS issue Excel vs Smartsheet
Hi I have this basic SUMIFS in Excel but cannot seem to replicate it within Smartsheet? =SUMIFS($F$10:$F$12,$G$10:$G$12,D3)*E3/100 Range F10:F12 are figures related to commission, Range G10:G12 are names of items that are already listed in a different column (D). Column E is an amount already in the sheet I'm looking for…
-
How to us VLookup in a Summary Sheet using Summary sheet fields and referencing another Smartsheet?
I will try to lay this out my Business Case in picture form. Smartsheet Plan: Larry-Editable Template - COEe In the Summary Sheet field: Project Request Status (COEE only) is defined as a dropdown list where I would like to use a VLOOKUP to pull status from another sheet using the Clarity Idea ID to match on and bring in…