-
Counting Unique Names in a column
I've seen variations of this but essentially I have a list of projects and within that sheet is the name of the project manager. That name may appear more than one time as project managers manage more than one project at a time. I'd like to represent the project load per project manager in graph on a dashboard (if…
-
Can one column take text from different fields?
I created a questionnaire in Forms and am wondering if I can have more than one Field populate a column? My example: we are asking about different types of projects, so want to customize the questions. But we want the answers from those customized questions populate the same column in Smartsheet.
-
Can you use Ancestors along with IF(And to check a box?
Hello, I need some help with a formula, if it is even possible. Scenario: Overall Project: checkbox column Level = 1 or 2 Exec Report Activity: checkbox column Level = 3, 4, 5, etc. Roadmap Report: checkbox column Is it possible to have a formula search for a checked box in the Overall Project column (Overall Project Check…
-
Lookup To Return Multiple Results — Using JOIN, COLLECT
Hello, I am trying to use JOIN, COLLECT to return multiple results but just can't seem to get it to work. This is what I have: =JOIN(COLLECT([Column111]:[Column111], [Column7]:[Column7], [Column1]@row, "N/A")) [Column111]:[Column111] is the range of the data I want to be returned [Column7]:[Column7] is the range of where…
-
Activity Log
Is there a way to generate a report from the activity log? What I want to do is to be able to quantify actions being taken within a time frame (i.e.: one month of time). For example, I would like to be able to track how many lines were added to our master sheet - and how many were removed. I would also like to be able to…
-
Filter a Report
Hi! I have a report shared to Editor-Cannot share. When they open it it is filtered to show just the current users information. I would like them to be able to filter by information in specific columns (Employee Email) however they cant filter in the direct column or by selecting filter at the top of the report. Is there a…
-
COUNTIF(s) for date range on referenced sheet
Hello, I've been searching all forums and can't seem to find a formula to fit what I need. I feel like it should be relatively simple but nothing I've tried has worked. I'm trying to get a count of patients who had their consultation during the year of 2020. I am referencing another sheet for the count. The columns are: I…
-
Using nested ISBLANK
I would like build a nested ISBLANK equation that looks at two cells and if both are blank, then give "X", if one of the two cells is blank gives "Y" if neither are blank results in "Z". I tried
-
Formula to subtract a cell with a Green tick image and show a total remaining
Every time I put a Green tick in the KEY column, I want it to subtract the TERMINAL cell within that row and to update the Remaining Terminals to be built. For example: I have put a GREEN tick in KEY5 So I want BRANCH2 to display the remaining terminals to be built, which should be 14 Hopefully I made sense :-)
-
Have Update Requests and Comments Carry Over across Smartsheet
We have several, SEVERAL sheets that capture very similar info. For example, SHEET A may have JOB # 1234, and that same job # is, also, found on 10 other sheets in SS. The problem I am seeing is that if an employee writes a comment or sends an iupdate request from the job #, in, let's say, SHEET A, another employee may see…