-
Checking a box using an IF/OR statement
Hi, I am trying to check a box if either of these statements are true, but I'm getting an Invalid Data Type error. The "Operational" statuses are from a drop down. Data Upload is "Operational" OR Retail Survey is "Operational" This is what I have: =IF(OR([Data Upload Status]:[Data Upload Status], ="Operational", [Retail…
-
How to Find the Furthest Status
I have 2 sheets. 1 with all my active job orders, 1 with all active job applications. I want to create a column on the job report to represent the furthest active application Example I have a job called "Accountant" on the Job Order sheet. The ID# is 1234 On the application report there are five applications with a Job ID…
-
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,…