-
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…
-
Can I Cross Reference a sheet in client account to a sheet in my account?
I'm trying to enter the following formula =SUMIFS({Barcode packing lists Range 1}, {Barcode packing lists Range 2}, [PIckup Date]25, {Barcode packing lists Range 3}, [KIT# / SKU#]25, {Barcode packing lists Range 5}, "Green") where the sheet "Barcode packing lists" is under my Smartsheet Account and the formula is on a…
-
COUNTIFS - Referencing two columns
Hi - I keep getting an UNPARSEABLE error with my COUNTIFS formula. My intention is to have a summary of how many documents are pending approval from another department - I need to return a count for how many rows have a date included in the "Date Submitted to OMB" column, but are missing a date in the "Date Returned from…
-
Formula Countifs
Hi. I need to write a formula in my Sheet Summary report. How do I add other countries on my counting.... all countries below belong in one category "South America" =COUNTIFS({JoseTracker Range 7}, "Argentina"......... Argentina Brazil Chile Colombia Mexico Peru
-
Combine data from two sheets
I've created two sheets to track different elements of product development. Each sheet has data associated with a product (product name, product key). Now I want to use the Smartsheet for Google Docs merge tool to generate a product report. My trouble is in rolling up the product data from the two sheets into one. The…
-
Adding ISTEXT to Formula: Referenced in Other Sheet
Good Day Smartsheet Community: I am trying to add ISText Criteria to be included if the Column has ACR. Existing Formula Below: =COUNTIFS({UAT Issue Tracking Sheet Range 2}, DATE(2020, 5, 19), {Issue Tracking Sheet: UAT Range 1}, "High", ISTEXT({Issue / Defect UAT LOG Range 1}), "ACR") Thanks for All Help In Advance.