-
Summarizing items by country
Hi there - I am working on a dashboard and would like to summarize content created in a region and then by country. Right now I have this set up manually with a formula based a static list of countries, but I am hoping there is something I could do that would pull the country list automatically from the column, as new…
-
Automate Harvey Ball based on % of checked boxes
Hi Smarties, Having a bit of a problem with this challenge. I would like to automate the [Progress] Harvey Ball's based on the % of checked [Completed] boxes in the children rows. If 0-24% of boxes are checked, the harvey ball should be empty. If 25-49% of boxes are checked, the harvey ball should be one quarter full. If…
-
Alert when Checkbox Column gets Unchecked
I have a formula column that gets checked or unchecked depending on some other things in the sheet. An alert goes out when this gets unchecked (and when rows get changed, not added) on an hourly basis. We recently got an alert saying that a row got unchecked but it makes no sense. I checked the cell history, and it was…
-
Count a row if the date AND Member Number both do not match another row
I am trying to create a formula where it creates a 1 in a column where the date AND the Member Number both in one row do not match the date AND the Member Number in another row. For example, in this row, the date is 05/20/21 and the Member Number is 987654. If another row also had the date as 05/20/21 and the Member Number…
-
If/Then Statement to Return a specific date
Hello, I am new to Smartsheet and though I feel like this should be a simple formula, I am stumped. I am hoping to create an automation that would calculate a due date from a date received based on the value selected from a drop down list. So if I choose option a from a drop down list (Permit Type), then add 30 days to the…
-
IF Statement for automatic checkbox
Hello. I have two columns "Gate Status" and "Gate Current (Mdays)". I'm trying to write a formula that does automatically adds a checkbox to "CurrentGateLate" column when the following happens. When "Gate Status" = "Gate 1" and "Gate Current (Mdays)" is greater than 10, then add checkbox. And....When "Gate Status" = "Gate…
-
Metrics Sheet Pulling from Reports
Hello All, I'd love to know if its possible (or a workaround) for creating a metric sheet to use in a dashboard using data from reports. We have 90+ Sheets that we can easily pull data into a report but its hard to get that into a meaningful chart. One specific example is we have 90+ sheets with rows that contain a rating…
-
Date Ranges with Multiple Conditions?
Hello, I am trying to calculate time windows by referring to previously entered dates, but am unsure how to build a formula that takes into account multiple conditions. For the highlighted cell, there are 2 conditions that I am trying to incorporate. For the first condition of "4 to 7 days after V3", I have the earliest…
-
Lost with vlookup or matching?
I am needing to update a Smartsheet to reflect the date listed in a cell from another Smartsheet. Both sheets have an IP address that can be match on as there are no duplicates. The feeder sheet with the date has 210 entries and master sheet has 2800 entries. I want to copy the date field from the feeder sheet to the group…
-
How to create this COUNTIFS with AND/OR/NOT
I cannot figure out how to create this formula to get the metrics. I can get each individual dept metric correct using =IFERROR(COUNTIFS({(Phoenix) Project Tracker - Aerial Status}, AND(@cell <> "No", @cell <> "Complete"), {(Phoenix) Project Tracker - Status column}, AND(@cell = "Complete"), {(Phoenix) Project Tracker -…