-
Reports - How do I add a specific cell from every sheet
I have a workspace that has several sheets and I want to create a Report that shows me the cell Column5 row 6 from each of those sheet, and if the content of that cell is equal to a specific content, then i want that sheet to be on the report. After that I want to add Column6 row 3 to the report from every sheet that met…
-
Does SmartSheet have an equivalent to Excel's "Name Manager" and "LAMBDA"?
I need a way to label a specific set of data or create a custom function that can be used in cross-worksheet formulas. Related to another query of mine, I need to take a list, give it a specific name, and reference it without having to navigate to the source sheet every time it's needed. For example, let's say I have a…
-
Cross-sheet references maxed out
I'm building a large master reporting sheet that cross references multiple other form response sheets based on a shared "incident number". I have six more columns of data to pull over from another sheet but have maxed out the cross sheet references (100 per sheet!) This master sheet then uses that data to create pdf's. I…
-
Requesting Status
I am an owner and an admin. Why can i not request status?
-
Anyone have a BRD Template?
Looking for a BRD template that someone may have built and wants to share.
-
Mysterious Date Changes... Dependencies and edays?
Hello, I've had a few users reach out to me today about seeing changes to their project plans, but no one went in to change dates. The activity log was clear of anyone specifically doing anything to affect the start and end dates. The recent user, after investigating her plan, had a predecessor (our dependency column) that…
-
How to make a Static Sheet Form for Multiple Cells?
Basically I have a questionnaire template for projects that I created that I need as a sheet to allow people to enter scoring rubrics and comments into a master sheet, but the projects need their own static sheet in each cell of the master sheet. Is there an easy way of doing this without having to create a million copies…
-
Issue with COUNTIFS Formula Referencing Auto Number Column in Smartsheet
I am currently working on implementing duplicate detection logic in our Baseline sheets within Smartsheet. The requirement is to identify duplicate Project Codes and assign a sequential baseline order (1st, 2nd, 3rd, etc.) based on the order in which rows are added. While attempting to implement the logic using a COUNTIFS…
-
How do you create a dynamic list of unique values from multiple sheets?
I am trying to create a "level of effort" calculation where we compare the count of bidded, lost, and awarded projects against a specific criteria, which is often a dropdown column in the source sheet. I have tried using JOIN, COLLECT, and INDEX from at least a dozen posts in the Community but nothing has worked to date.…
-
Help with functions for attendance tracker
I'm attempting to create an attendance tracker that will add up the total points for a given representative based on the type of 'event' such as No Call No Show, Late Arrival etc. I have a sheet set up that automatically enters the number of points based on the event, calculates any adjusted points and shows points…