Right now I'm trying to experiment with pulling information from one sheet to another based on if the creation day and submitter match, and I'm struggling to get it to work. First I was getting an "IN…
How can I change this formula so that if there are NO start dates and end dates in a row when it is set to Not Started, it does NOT show as flagged. Here is what it is currently doing: Here are the fo…
Hi all, We're having an issue where the 25,000,000 formula cell reference limit was reached after adding a new column, but even after deleting way more columns and cell references than we added, it's …
I have a project tracking sheet where the "Assigned To" field is a contact list. For the first row of the sheet, the Assigned To cell is calculated based on a Summary Sheet value (=[IT Contact]#). All…
I have tried this multiple ways and it's still not working. Any ideas would be greatly appreciated. Source data: Destination sheet: Into the Destination sheet, I want to pull the "Task Start Date" whe…
Hi team! I'm hoping one of you wise Smartsheets gurus have some guidance. I am trying to build out a "checklist" that will populate with data from another form and for the life of me I cannot figure i…
Hi, I have a Start Time column and an End Time column and I would like it to calculate the hours and minutes of duration into another column. I scoured Smartsheets and found information on this, see l…
Hello, I need help adding one more criterion to this formula I am using to pull data from one sheet (Budget) and give me a total expense in another sheet (Staffing). =SUMIF({5320182 VENDOR}, @cell = […
Hello all, I'm looking to build a formula that will return the digital object identifier (doi) string from a paper citation. The problem is, sometimes it the last piece of the citation, sometimes ther…
I have a field (column) in my source sheet named [Hub/Site CLLI]@row that I need to find the number of instances contained in a drop down list named {Tinas node_comparison - All CLLIs} in the target s…