-
Poor Man's Datamesh
Prior to getting Datamesh, I devised a solution to transfer data from one page to another, without having matching columns. This process uses an intermediary sheet. It's kind of a pain to set up, but it works well and requires little to no maintenance. I still find some very small use cases where this comes in handy.…
-
How to count different text values listed in a column
I have 2 columns/ranges. I need to count if range1 is value text1 and range2 has values text2, and text3, and text4. This formula works so far =COUNTIFS([Range1]:[Range1], "Text1", [Range2]:[Range2], "Text2") However things get wonky when I wan to add more text values to Range 2. So it would kinda look like below. But…
-
Year-to-year best practices when it comes to metrics based on dates?
Greetings- I need some advice in regards to best practices when it comes to tracking multiple years and what to do when one year ends. For example, my SS below tracks submissions via the form by month and year using the formula below for January. =COUNTIFS({Community Engagement Request Range 1}, "1", {Community Engagement…
-
Formula Help - Childre
I recognize that this is probably very easy and there are several topics on this already in the Smartsheet community. I swear I have searched them all and the suggested solutions are just not working for me. Any guidance is appreciated. I've created a very generic task list, that includes columns for Start Date and End…
-
Task that lasts the duration of the project
I have a task I want to track that lasts the duration of each project. However, since the start/end dates can't be formulas, I'm wondering if there's another way to set this up in my template?
-
Grid help needed to reference different POs with changing totals?
Greetings- I created a SS for my finance dept. Basic form where they can select a vendor from a drop down menu and enter that month's bill with what they paid. Each vendor has a different PO number with a different total amount on that particular PO (purchase order). Im having trouble figuring out how to start with a PO…
-
I am looking for creative ideas on how to create a gap analysis
We are currently in the process of assessing our skill proficiency levels, ranging from Level 1 to Level 5. To visualize this, I've created a heat map that illustrates our current skill landscape and the proficiency levels we possess as an organization. As part of our strategic approach, we are now reaching out to external…
-
Pls Help! Automating Rollover of dates Based on change of a status
Hi Everyone, Can't seem to find much information on this topic can anyone help with the below? Or point me in the right direction. Trying to create an annual calendar with deadlines. The calendar includes Monthly, Quarterly & Annual Deadlines. The idea is that when a team member changes the Tracker column to "Completed":…
-
Multiple IF Statement Returning Different Text
Hi Everyone, I am trying to write a formula that will look at a cell and if certain wording is not in the cell then return a value to a new cell. The information is from a multiple dropdown selection column. Here is an example of what i am trying to do. Dropdown List Would Populate the Missing Color column based on a…
-
How to count values if either of two conditions are true
I have two sheets: Sheet A and Sheet B I would like to count the number of cells in Sheet A, Column A and Sheet B, Column B that have the value "Liver". Both sheets are stored under the same folder.
