-
Using IF to look at a Checkbox field and return "XYZ"
I am creating a Status field using IF function. I'm trying to look at a check-box field and return "status" (ex. "Tooling Complete") if the box is checked. I've tried IF(NOT(ISBLANK(... but a check-box formatted field seems to register as not-blank whether it is checked or unchecked. Does anyone know a different function I…
-
Automatic Checkbox w cross-sheet & lookup
I'd like to create a series of formulas in a sheet that will automatically check a checkbox column if certain conditions exist. The 2 sheets are ATTENDANCE and SIGN IN. The Sign In sheet has attendee names in the first (non-Primary) column (in the order that the attendee signs in, not alphabetized) and has a date in…
-
Nested if()
Hello great community. I'm new in Smartheet and I've a problem and even don't know if a solution exists. I'm trying to create a sort of automatized timesheet for my team. I would like them to connect to the same sheet. They have to select their name in a list ("Team" column), and the type of mission they've managed in an…
-
Work days formula
Hi, Is there any way you can advise of a formula where I can set something up that picks a date in a column and I set a specified number of working days which yields the final date. So if I have a cell with a date of 10/09/19 and the working days I want to set is 14, what would the formula be like? I have tried using the…
-
Mandatory text to activate checkbox
I have a "Notes" column that requires text before the checkbox under "Req Attn" will be checked, kicking off conditional formatting in other columns. I found this thread and tried to implement the suggested solution: https://community.smartsheet.com/discussion/formula-help-if-cell-blank-checkmark-cannot-be-checked I…
-
COUNTIFS - Overdue tasks
Hi, I am trying to count live tasks that are overdue but I am getting #INVALID DATA TYPE This is the formula I am using =COUNTIFS(Status:Status, <>"Complete", [End to End Due Date]:[End to End Due Date], <=TODAY()) Any ideas? Thanks Karen
-
Multiple IF Statement based on Multiple Criteria
I am currently working on automating an "Assigned To" column based on postal codes. There are multiple postal codes options per individual with three individuals. Is there a way to create a (albeit very long) formula to populate? I'm currently working with =IF(OR([Postal Code]@row = "01xxx-09xxx", IF([Postal Code]@row =…
-
IF, AND, OR Formulas
Using my data set, I would like to know by region the number of multi-year reporters and new reporters (2018). I will count either status as an active reporters. Ex. Africa= total 2 active reporters -Ghana: Multi-Year Reporter -South Africa: New-Reporter -Nigeria: Did not report The following formula will count the number…
-
Summary Task status - automatic
Hello, Im very new to smartsheet, so, im sorry if this question is too "basic". I have a summary task with 3 or 4 children tasks. I would like to know if there is any way to automatically update the status of the summary task: - If all children are completed --> completed - If any children is on-going --> on-going An the…
-
IF or IF AND Formula conditions DATE
Dear, I appreciate your help. I need to create a formula that changes the status column depending on the following conditions. (The image in the example table has reference TODAY = August 28, 2019) 1) If the Balance column is equal to 0 (Green) 2) If the Balance column is less than 0 (Yellow) 3) If the Balance column is…