-
Copying comment text into another cell but only when a certain value is triggered
Hoping you can help! I'm trying to setup a formula where if I have a Red RYG ball in a cell of a task row then the comment next to it copies into a different cell (on the same sheet) for reporting. I know I could just create a report which looks at values in those columns and trigger only when there's a red ball along with…
-
Please Help with Summit Formula
I want to if assigned person is correct to then take information from one cell and transfer to a different cell automatically? This is the formula I have so far however when I enter this it gives the #unparseable error =SUMIF([Fielder Assigned]:[Fielder Assigned],"Name",[Rural Mileage]:[Rural Mileage)
-
Issue with COLLECT and duplicate dates
We are trying to achieve a formula that finds the most current Tracked task's Variance from the Baseline date. Tasks are arranged in a table/schedule in step by step order. I'm having an issue with this formula here: =INDEX([Baseline Variance]5:[Baseline Variance]128, MATCH(MAX(COLLECT([Task Complete Actual]5:[Task…
-
File name of the sheet in a cel?
Hello all, Maybe simple question, but I would like to have the a cel inside a smart sheet filled with the filename of the sheet? How can I do this easy? e.g. CLIENT-001-sheet011 in a cell? Thanks, Eric.
-
Merging Cells and Exporting Reports to PDF via the App
Hi there, I love Shartsheet, but one constant aggravation for me is the inability to merge cells. In my quest for a solution, I've come across a few posts on the blog (some as old as 2015) where similar requests were answered with a generic "we'll pass this along to our developers" type response. Just curious: is this…
-
Best Practice: Sharing a Report
I have several sheets that contain course development information. Some of the information is private and not intended to be shared . I created a report for a vendor that pulls information from one sheet (and that one sheet pulls data from 4 or 5 other sheets). Our goal is for the vendor to update the Status column in the…
-
Jan 10th, 2019: Cell Linking between sheets with the new UI
Is there any updated information for linking cells between sheets with the new UI? It looks like the direct way is still in tact (where you right-click on the destination cell, click on "Link cell from another sheet", and file through the sheets in a pane on the left until you find the source sheet, and then you click on…
-
Added row in smartsheet cannot be retrieved in reports
I have a sheet with all the data I need for reports, dashboards and other summary sheet. My trouble is, whenever I add a row in the source sheet, it is not reflect in my reports. Example, I have a report with a simple criteria/filter of retrieving any row with type = PROJECT. However, the newly added row is not reflected…
-
Reference another sheet using sheet name
I'm almost certain that there is no solution to this situation, however, here goes. I have a workspace with approximately 35 project sheets. Each project has approximately 50 tasks and each has a schedule status in a "Schedule" column. I want to be able to count these tasks based on their stats and report on the entire…
-
Inter Project dependencies
Hi, I have multiple projects to be managed under a program. I have a task1 under Project A which has dependency on task2 of Project B. How can I mark dependencies between two project tasks? thanks, Pragati
