-
I need to use an IF / THEN formula to compare a cell from one column to a cell in another column
I could really use some help! Thank you in advance! My STATUS column has the following colored options available per cell: Red, Yellow, Green and Blue. I am looking to use the following IF / THEN statements: 1. In STATUS, if the DELIVERY DATE is within SEVEN (7) DAYS of the START DATE, the LIGHT is RED. Can the DELIVERY…
-
Process flow that also includes daily task checklists
I am new to SmartSheet. I've developed a comprehensive process flow for our recruiting process. It has the tasks to be done, start/completion dates, who they are assigned to, and other steps. But there is one thing I can't figure out. Within the process, there are certain action items that need to be done on a daily basis.…
-
Indenting on smartsheet causing calculation error- help?
Hello, My organization uses smartsheet as a scheduling tool. We have a column that calculates what resource hours we have remaining for available scheduling (formula =((# of crew members * work days * work hours) - SUM(CHILDREN())) in my case specifically, =((8 * 5 * 7) - SUM(CHILDREN())) ) If a work order has multiple…
-
Getting top-level heading's rank
I'm trying to write a formula that extracts the position of the current hierarchy's top-level heading within the set of all top-level headings. The purpose is to drive some conditional formatting. i.e. If the current row is under the first top-level heading, make it green. If it's under the second top-level heading, make…
-
How do I get conditional formatting rules to update based on "today" as the date.
Hi All! I have conditional formatting set up that is looking for tasks that are due to start today (see first picture below). I chose the "Today" button when I set these up, but they populated today's date and they don't automatically update when I open the project plan after initial set up. In the help library, the…
-
Calculation within IF statement
Hello, I have a column formula that calculates the number of days between a ticket request and the completion date. I want the rows that do not yet have a completion date to be blank instead of "#INVALID DATA TYPE" and I tried to use to IF statement to do that - If completion date is blank, leave the cell blank, otherwise…
-
Have cells inherit background color
So, I have a helper sheet that tracks Budgeted, Committed and Actual spend for an individual project based on the end date from a project sheet. The sheet is laid out where a total of 24 months have their own columns in chronological order from left to right. There are four rows for Budgeted, Committed, Actual and the last…
-
Nested IF statements counting Children color status
Hey community, I've found simpler versions of this in the messages, but can't get this one correct. The logic I'd like to express is: If any children under Flag show a Red, then the parent cell (Flag1) is Red If children Yellows are >= Green children, then the parent cell is Yellow Green otherwise. The code I have is:…
-
Frozen/Unresponsive Sheets
We're experiencing freezing/unresponsive sheets after a few moments of being open. This has been going on for a few days. Anyone else experiencing this? Thanks
-
Percent Formatting applied, but entry of 100 is shown as 10,000%
I have the entire column formatted as a percent, but when I enter 100, it shows as 10,000%, or when I enter 1 it shows 100%. Would like for the number entered to show that percent.