-
Summarise Tasks into single cell
Hi there Smartsheet Community! I have been a smartsheet user for a few years now but this is my first post with the community (so i'll try my very best to describe my issue) I use two different sheets for planning in my company, which is currently manually updated. I am hoping to link these sheets together so that…
-
Function Help - Sheet References
Hi there - I am working on building a slightly better project tracker for our organization. We currently utilize calculated fields that we have to define for each new project, and sometimes the project does not have enough project rows to account for all items we are tracking. I need help with a specific formula that would…
-
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…