-
Sharing Templates
Hi, I would like to share multiple templates that I have designed so others can use within my company. Does Smartsheet have the capability to share a blank template?
-
Speed up loading of a Report linked to multiple Sheets
I have a number of Workspaces representing different Projects. I want to be able to Report on specific Sheets within each Workspace. I have several different Reports, each uses data from a different Sheet within the Workspace(s). Whenever a new project (Workspace) is added, I amend the Report data source to include the new…
-
Multi Select Look up
I'm trying to see if anyone has any ideas of a formula that can been written for the following example. I'm trying to get the contact(mail) in sheet 2 to populate sheet 1(Approval Seq 1 Contact) column. There is 2 criteria (Division and Seq.1) on sheet 1 need to match (Division, Sequence #) on sheet 2 to return the contact…
-
How to build a report that will count different criteria from a column?
I have a dropdown multi-select column in my sheet. It can be seen below: I want to be able to build a report in Smartsheet that will be able to tell me the count of each different category. For example, a count of all the clients that selected American/Alaskan Native as their race. Or, all the clients that selected…
-
formula work one one sheet but not another
Hello I have a formula =IF(COUNTIF(IndexKey:IndexKey, IndexKey@row > 1), 1, 0) that checks all the indexkeys in the column to see if there are any duplicates. This works perfectly on my tester sheet which is an exact copy of the sheet I want the formula on but for some reason doesn't work on the main sheet and returns 0…
-
Formula to check box if cell contains Date OR Text
I have a nested formula that currently involves one check box be checked and three date columns to contain dates in order to check-mark as 'Complete.' However, I discovered one of the date columns involved may contain text from time to time (as a date is not always applicable to this particular field). How can I revise my…
-
Creating a survey & collecting feedback for a list of submissions
I've created an intake form and sheet to collect project request submissions, and now need to create a way for the project committee (8 members) to score each submission using a simple 4 value Impact/Effort score that I'd like to present in a Survey Form so I can collect the data and consolidate for presentation on…
-
Nested IF Statement with OR and AND functions
Hello, I am trying to create a nested IF statement. The formula is fed by two columns Status and End Date. The formula should return that IF status is one of "Completed" or "Adoption/Sustain" AND the end date column has a date (any date) then return "Yes" if true. I keep getting Unparseable or Circular Reference errors.…
-
INDEX/Match Error?
Hello, I have the following Equation written out: =INDEX({Brand Manager}, MATCH([Brand Channel]@row, {Brand Channel}), 0) {Brand Manager} and {Brand Channel} are pulling from Sheet A. Brand Channel is a column that is in Sheet A and Sheet B. The equation is written in Sheet B. My expectation of the equation was to pull in…
-
How to aggregate sheet summary data into another sheet
Hello, I am currently working on developing a workspace to track system testing. The way the workspace is currently set up is having a summary level sheet that has each script, and then a folder per script. Within each script specific folder, there is a script summary sheet and a test script sheet. There can be multiple…