-
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…
-
New sheets created in one browser tab not available in other browser tabs.
When I create a new sheet in a different browser tab - you know, because we can't open multiple tabs anymore - the sheet is not available in the other tabs. I went out of the folder and back in to give it the opportunity to update, but it didn't. It does not see like the browser tabs are working very well. Maybe we should…
-
Reference a Cell in another Sheet in a Formula?
Howdy! I'd like to count the number of occurances of a specific value in a column on another sheet. It works great this way, but within the same sheet: =COUNTIF([Column4]17:[Column4]26, "Red") Is there a way to select a range of cells on another sheet and return (in this case) the number of them that are Red? Thanks!
