-
Deleting one outgoing cross-sheet reference ended in ALL references from the same sheet being delete
Hello, I spoke to Support on the phone yesterday but we haven't had a definitive answer on what the expected behaviour for this scenario is. I'm curious to see what other users have experienced. In the the "Edit or Remove links" > "Outbound links" section of the Cell Links: Consolidate or Maintain Consistency of Data…
-
Index or Vlookup or What?
Hey All! I have a question for the community that i'm having trouble figuring out to return a certain value to another sheet based on criteria. The pic I attached shows a project budget setup and I am wanting to pull data from the Budget cell based on the Job ID and the Cost Category. I'm not sure if it is a Index - Match…
-
SUMIFS with 3 conditions
Hi I am trying to calculate the total number of worked hours within a week/ month which match 2 more criteria. At the moment I have fr the monthly formula 9 September): =SUMIFS({003 Project Timesheets Range 2} , {003 Project Timesheets Range 1,"Noemi K", {003 Project Timesheets Range 3} , "Testing" and ({003 Project…
-
IF Statement - If two columns match any two columns on the page, flag it
Right now I have =IF(COUNTIF([Part Number]:[Part Number], [Part Number]1) > 1, 1) If the part number in row matches up with another row, it lights up a flag. I want to be able to add two checkpoints... If a "part number" and "ware" in one row matches up to another "part number" and "ware" on a different row, light up the…
-
QBO and Smartsheet
Is there a way to link an invoice from QBO to a field in Smartsheet?
-
Help with Vlookup + date
I explain, I need to create an expiration date from a drop-down menu where the different types of payments of my clients are informed. Example, if a customer's account is "up to date" it means that the due date will be the issue date + 0. Also if another customer has a "credit" deferred payment type, the due date must be…
-
pdf and excel files into multiple sheets via Gantt?
Hi there, trying to make a production line more efficient and I need to attach a file to each order (each order is a separate row). We run off of multiple sheets, and have reports broken down to each department. For example: Main Sheet: Gantt Production - includes all orders (which are linked to multiple reports) Report:…
-
Server/Local sheets get out of sync, some permanently
Hi all, I am working with SS support but I thought I would reach out here as well According to T2 support ...If our server has not processed all data/ formulas before a save is made the sheet may show a different version than our server shows. In most cases the dirty save only lasts for the first 2 rounds of saves.... This…
-
Getting Status of Children to roll up to Parent Row
I have Parent tasks with Children tasks in a dropdown list column. The options for the children are: assigned, in progress, complete. would like to have the parent status display be blank if none of the children have a status selected (all are blank), display "Complete" only if all the children have a complete status,…
-
Linked Cell Format Issue
Hello everyone, I have tried looking for this topic, however, I can't seem to find anything. I have a source sheet with dollar amounts and the cells include a number such as $100,000.00. When I link the cell to a new sheet, the number shows up as 100000 Any idea how to fix this? Thank you. Sincerely, Diego