-
If Not Blank Statement Help
Hello, I am trying to write a Column Function If statement in the "Task Status" column that will update my status to be "Complete" or "Incomplete" based on if certain cells on my smartsheet are blank or not. So far this is the formula I've put together, but I can't quite get it to work. Would somebody be able to take a…
-
Find Unique Dates from 2 Date Columns
Problem of the Day: I have 2 date columns with different dates. I want to create a 3rd column that lists only the unique dates from both columns. Suggestions?
-
Drop down multiselect column - getting count data
I have set up a form with a multi select list and I need to be able to tally the selections against each of the items. I have looked on here a lot and tried various versions of COUNTIF and COUNTIFS and COUNTM and have exported to Excel and tried to do it that way and cannot figure out what to do. Can someone point me to…
-
Number count formula
Hi All. I have a column of data that is strictly numbers. I am trying to build a formula to look for duplicates and also at the same time not count any blanks in the column. The normal formula i would use for this is =COUNTIFS([Column Name]:[Column Name],AND(@cell = [Column Name]@row, ISNUMBER(@cell))). However some of the…
-
Formula to color RYG balls based on date/deadline
Hello, I'm trying to alter the color of our RYG status balls based on the proximity of the date. For example: Yellow - if today's date is within 5 days prior and 5 days after the deadline date noted Red - if today's date is 5 days + after the deadline date Green - if today's date is before the 6 days + before the deadline…
-
Subtraction across two sheets if row and column match
Hi community, I have separate sheets for tracking monthly budget and actual expenditures. They have identical layouts (see below). Problem is, the budget goes to 2024, so I really need a formula that can calculate the variance between budgeted and actual. The logic would be something like: =budget(where row = "Feas-591:…
-
Reporting Indicators
Hey All - I'm creating a graph in SmartSheets, and wondering if there's a way to create an indicator (line, tick-mark, etc.) that would show as part of the graph where I could mark certain changes. In this graph, I'm showing Employee Capacity vs Forecasted Time, and I want to indicate when an Employee either left/joined…
-
It's Only Blocked Until I Kick It
I have a formula that leverages some sheet summary formulas and returns a true/false to support a report filter. When I change data in the sheet the sheet summary formulas sometimes return a #BLOCKED, but it is not consistent. When it does, if I go into the formula and edit it (without actually changing anything), then the…
-
Highlighting duplicate data based on two conditions
Hi, I want to make a formula to highlight whenever to cells contain the same data on the same date. I'm working with a marketing calendar and want to find a way to highlight whenever two campaigns are planned to go out to the same country on the same date. So, if two (or more) cells contain the same date as well as the…
-
Help with an IF AND formula
I should be getting better at figuring out the punctuation on these formulas. Can someone see what I am doing wrong here? If Arch review is completed, answer is 0. If Arch Review is Pending, than answer is 8 for 2 or less servers and 16 for 3 or more servers: