-
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…
-
Gantt chart with multiple start/end dates
I have a sheet tracking when staff are on call, so several start and end dates. I need to be able to see all of these dates on a calendar/Gantt chart. Is that possible?
-
How to make a change in smartsheet after a workflow has already been executed?
I have a workflow that sends data from one sheet (A) to a second sheet (B) - this workflow is executed when the completed column changes to checked, using a checkbox. So, once the checkbox is checked on sheet A, the data moves to sheet B. There are times when the data needs to be updated or changed on sheet A and I can't…
-
COUNTIFS for Children Rows
Please help This formula works for Countif and .. =COUNTIFS(Status:Status, "In Progress", [Client Report]:[Client Report], =1) When I add in the Children to restrict the formula to children tasks I get an unparseable error ..please help..what am I doing wrong ? =COUNTIFS(CHILDREN(Status:Status, "In Progress"),…
-
Vlookup with Left Function
Hello, Below is my formula, and I am not seeing why it is still #NoMatch? I am attempting to Vlookup the base Job# (ie: 190347), by using the =LEFT function to obtain the first 6 characters of the cell. Then using the first 6 characters, lookup that base value from a master file to vlookup the PM and SUPT =======…
-
Programme level reporting - cell linking Vs. sheet summaries
Hi, I'm building programme level reporting which spans about a dozen projects. At the moment, I'm testing two routes - 1. sheet summaries and then a sheet summary report, and 2. cell linking. Cell linking is looking like the preferred option because sheet summaries aren't dealing very well with percentage formatting, at…
