-
Did the COUNT formula change to include blank?
I want the COUNT formula to only count checked boxes. Yesterday, this was the way the formula worked today, it counts checked and unchecked boxes. Does anyone have any idea why this changed?
-
Creating a dashboard from a sheet with multiple data types
Hey all, attached is a screenshot of a sheet I am trying to create a dashboard with. The issue I am having is creating a chart/view to show completion of a year review meeting by student. The 'Complete?' check box is what we are using to mark completion of the meeting. When I try and make a dashboard from this sheet and…
-
Checking checkbox if the cell on the same row in a different column contains one of several values
Hi all, I'm currently having a little bit of difficulty writing a formula for a checkbox column. I intend to write the formula so that the box will be ticked if at least one of three values (people's names in this context) appear in a different column on the same row. I can get it to check by only specifying it contains…
-
Creating a Booking System with a Time Component
Hi everyone, I have the following asset booking system and received feedback that I should add a time component to it: Unfortunately, I haven't been able to get it to work correctly as, in the above screenshot, you can see that the booker is stating the asset is available when it is not. Additionally, the 'Assignee in…
-
How to create a source sheet that automatically updates other sheets if data is removed?
Our organization has roughly 150 program participants and we have a number of different sheets that have each participant listed as a row with various data in columns. I am curious if anyone has experience with creating a source sheet of contacts so that if I add/remove a participant from the source sheet, they get added…
-
IF Formula
Hello, Not sure how to create column formula for the following criteria utilizing RYGB color formatting: • 0-29% red • 30-49% yellow • 50-99% green • 100% blue
-
Health of Work/Color Formula Question
Hello, I am new to Smartsheet and have no idea on how to properly articulate the following rules in a formula. I am using the colors RYGB and following statuses: • New = green, if end date is one week away yellow, If end date has passed red • In progress = if % complete is between 80-90% and not overdue green, otherwise…
-
Cross-sheet COUNTIF Formula w/in a specific date range
Hi all, Looking for some help on a formula I have been working on. I am trying to count the number of requests that have been submitted between a specific timeframe (2/14/22-3/18/22). The date column I am looking at is in another sheet (Date OnlyN). =COUNTIFS({Date OnlyN}, >=DATE(2022, 02, 14), {Date OnlyN}, <=DATE(2022,…
-
Can IF function be used with symbols and cross-sheet referencing?
I'm trying to create a formula that shows the Green and Red symbols based on information from a different sheet. Current formula looks like this: =IF({Open House Order Form Range 1} = Office@row, "Green", "Red"). I get an invalid operation error but I can't figure out why. I'm wanting to know if any cell in the cross-sheet…
-
COUNTIF with date range and another critieria
Hi, I'm trying to count the number of rows which have a 60-day opt-out window between x and y and where the "Monthly DataCor Revenue" is blank. This formula works (y'all helped me with this): =COUNTIFS({Lite 60 day opt out}, AND(@cell >= DATE(2022, 8, 1), @cell <= DATE(2022, 8, 31))) but I cannot get an answer when I add…