-
CountIFs
Creating a function to count certain states in one function listed below: =COUNTIFS([Travel State]:[Travel State], OR([Travel State]@cell = "CO", [Travel State]@cell = "TX", [Travel State]@cell = "WA", [Travel State]@cell = "OK", [Travel State]@cell = "NM", [Travel State]@cell = "NE", [Travel State]@cell = "MO", [Travel…
-
Average of only particular selected cells
I'm trying to calculate the average of multiple parent cells in a column, not the whole column, but can't find the correct formula to use. (The parent cells are calculating averages based on other criteria.) TIA!
-
Count Values of X if Y is not the same for the other Xs
Hi, thought I could use some variation of =COUNT(DISTINCT(COLLECT({Advisor Rep ID}, IF{Client for the rep id is not equal to any of their other on the sheet}, WHERE {Case Consultation Meeting Number}, =1, {Submission Year}, =2024, {Status}, <>"Not a Case"))) But try as I might, can't get it to work. Thanks for your help!
-
How to remove the unnecessary commas?
I worked out this formula with someone during a ProDesk session but they weren't sure how to remove the commas when they weren't needed so I'm hoping someone else maybe has an idea! The formula: =JOIN([Inspected Employee's Name 1]@row + ", " + [Inspected Employee's Name 2]@row + ", " + [Inspected Employee's Name 3]@row +…
-
Index/Collect Two Separate Dates and Compare Them to Return Highest Date
I'm trying to use Index Collect based on a client name to look at two different dates in a separate sheet, and compare them to pull the highest date. We have 1 sheet that we log all contacts, and there are 2 types of contacts "Type1" and "Type2". Then, we have an overall summary sheet that shows the most recent contact.…
-
Dynamic View Template
We are needing the ability to create a Dynamic View template. Our organization creates many project schedules throughout the year, so a template would ensure consistency as well as simplify the process for creating new projects. Currently, I would have to create a dynamic view for each project, specify the columns shown,…
-
Kanban board integration with Smartsheet (multiple sheets to one board)
Hi all, We currently use a roadmapping software called Roadmunk and moving over to Smartsheet. One thing Roadmunk is able to is enable very easy drag and drop swim lane or timeline views from a data source. The closest functionality Smartsheet has is card view which does not provide ability to define lanes on the Y axis.…
-
How to "Freeze" Values in a Row with Dependency on TODAY()
I have a Sheet 1 that collects forms submitted by Program Developers every 2 week to provide an update on a program development project. One of the form fields is "Program Code". I have a Sheet 2 that lists all of the programs currently in development. One of the columns (Stage@row) is a dropdown with possible values of 1,…
-
search function not bringing user to the row of the "found" item.
Hello, Some of our users are noticing search issues today with wildcard searches in grid view. The search function searches properly however is not bringing user to the row when clicking the found item. In some cases clicking the up or down arrow on the keyboard will refresh it, for others it's no where near the item in…
-
Help with a weekly updated formula
Hello! I'm still a beginner smartsheets user, and while I am decent with excel the live updates is still very new. I'm trying to create a formula that will pull information on a weekly basis, M-F, that updated for each week and didn't pull from the previous week at all. For example in this screenshot, I would like a…
