-
IF, AND formula for checkbox
Hello, I'm trying to make a formula for a checkbox column where if the column titled "Expected result" is positive, but the "Results" column is negative, then the checkbox will be filled (and vice versa if expected is negative and result is positive). However, I cannot say if the expected result column and results column…
-
need to have a formula auto fill but only if there are dates in specific cells
I am trying to get the cells to auto fill depending on the dates entered next to it. I can't use the convert to column formula feature because it's not a guarentee that all data in the start date and end date will be entered. We are doing a market review for a certain group of team members and need to let them have the…
-
Using OR/And Function
I am trying to create a formula for the following: 45 days before the deadline – where work is completed less than 65% - Red alert 65-75 % - Yellow Alert 75% more – Green Alert I am not able to combine two Parameters to determine the colours. See an example =IF(OR(AND([Revised Planned Finish]@row - [Revised Planned…
-
Bulk Updates
Hi, I have multiple sheets that is getting data with formulas from one specific sheet that gets updated 3 times a week. I'm calling this sheet as the bulk update sheet. Since SmartSheet doesn't allow to import from excel on that particular sheet, let's say override the existing, all the time I need to copy paste all the…
-
Formula Criteria - IS ANY OF based on Multi-Select Dropdown
Hey, So I'm going to guess that the answer is no, but I'm going to hope the answer is yes. We have a board that is used to help track hot or critical inbound items. The goal is to retrieve dates from our, lets call them 'Build Trackers', based on a series of criteria in order to help inform the priority and urgency of…
-
% Allocation Formula for Assigned To column
Hi @Genevieve P. Can you please help me come up with an IF formula to use in the % Allocation column for my sheet? This is what I am trying to formulate: If Bob (from the ‘Assigned To’ column) reaches greater than 100% allocation (from the sum of multiple rows), make the ‘Assigned To’ cell Fill in Red for wherever Bob’s…
-
Copy value from one cell to another depending on checkbox value
I am trying to get one value to automatically pull from one cell to another based on whether or not a check box is checked. Would this be a match formula? WE are doing a market review for a group of employees and we want everything to be auto calculated based on if we mark it as relevant or not. My plan is to sum all of…
-
Copying checkboxes from one sheet to another sheet
Good morning everyone, I have 2 sheets which are identical in formatting. Sheet 1 - Team Tracker - all members of my team enter information. Sheer 2 - Individual Tracker - I have an automation set up that copies information to separate individual tracker sheets based on a contact list. The sheets are identical in…
-
Index/Collect that should work, but is not returning values.
Hello, Community! I've tried support and Pro Desk so far without success and could REALLY use your collective brain power. Here's the situation: I'm trying to use Index/Collect to bring the value of A into D where the Year for Role = 0 and the Role matches the FS_Description (same value, just different label). The same…
-
Removing Partial Text From Prefilled Column
Hello! I'm currently using the following formula to extract just the time =SUBSTITUTE([Completed Timestamp]@row, DATEONLY([Completed Timestamp]@row), "" When used with automation/move by a check box being true, it populates correctly. However when using automation/move when rows are added and matching a "Category" column…