-
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
-
Database of information from one sheet to another
Hi all, I have a sheet that is a "database" of about 400 records. I want other users to be able to input one column of that sheet (Media Company Dropdown) in a form or other sheet and for the next seven columns to autopopulate. Is this possible? Would VLOOKUP be a solution? I've read a few forum posts that said that…
-
Collect Criteria not being filtered
My nested COLLECT function's Criteria does not appear to be working because the formula runs into errors when a duplicate date is found before the actual date that should be being pulled. =INDEX([Baseline Variance]5:[Baseline Variance]128, MATCH(MAX(COLLECT([Task Complete Actual]5:[Task Complete Actual]128, [Milestone Type…
-
Use triggers from Smartsheet?
Working on a new workflow. Today's workflow is manual and based on emails. I'd like to use the webform to collect the required data (done) and then, based on specific conditions in the sheet fields trigger actions in other system - from generating email to open a service ticket etc. I watched the movie of the docusign -…
-
Find Value in List in Cell
I have two sheets---one with a list of program that includes rows with a cell that has a list of course prefixes. EXAMPLE: ROW 1--->Doe, John | doej@xx.com | BUS,CUL,MGT ROW 2--->Smith, Elle | smithe@xx.com | HOS,SUS Each row has three columns: name, e-mail address, and course code prefixes. On the second sheet, I want to…
-
Share Data Across Two Sheets
I have a master sheet with data for a list of courses to be developed in the new term. I am working with a vendor on some of those course. Let's say 10 of the 15 courses. The sheet also has a column indicating the status of the development. I do not want the vendor to edit or view this sheet. Instead, my thought was to…
