-
Can Smartsheet do an "if" "then"
Example would be I have two columns. I'm trying to populate column 2 based on the value of column 1 as follows: if the value in column1 is $75,000 - 250,000 then populate column 1 with $2500 if the value in column1 is $251,000 - $1,000,000 then populate column 1 with $5000 if the value in column1 is $1,000,000 or above…
-
I'm trying to find the number of cells that meet a criterion within a specific date window.
=COUNTIFS({Access Request Range 5},>=(2021, 7,1),{Access Request Range 5}, <=(2021,9,30), {Access Request Range 2},"Approved")
-
Date format on charts
Hi there, I want to track the amount of tasks / date. When I convert my report summary into a chart I think the dates are reformated into numbers. My data set looks like this: And my Chart looks like this: As you can see there is an issue with the date format... I've tried everything but couldn't find a solution. Thanks…
-
Adding N/A as a dropdown so that it doesn't display 'Invalid'
Good day, I want to add not applicable as 'N/A' on a dropdown to this formula such that it doesn't display 'INVALID'. Grateful for any help. =IFERROR(IF(ISBLANK([Expiry Date]@row), "", IF([Expiry Date]@row <= TODAY(), "Red", IF([Expiry Date]@row <= TODAY(90), "Yellow", IF([Expiry Date]@row > TODAY(90), "Green")))), "")
-
I am coming up with formula errors when trying to make the parent flag red if any children are red
The CHILDREN have, for example, =IF(AND([End Date]323<TODAY(),[% Complete]323<>"1"),1,0) and that works to turn flag red in all children but tried all kinds of COUNTIF formulas to also turn the parent red if any one or more of the CHILDREN are flagged red but all attempts are failing. Any ideas?
-
Trying to tally a list of carious data within a list.
I have a column that is specifically purposed for physical locations. Is it possible to tally the locations mentioned with one function or do I have to make 38 functions that mention their own specific data.
-
Nested If Statements
Rookie here - can someone please tell me what I'm doing wrong? =IF(AND([Started?]@row = true, (TODAY(20) > [End Date]@row, "Urgent", IF(AND([Started?]@row = true, (TODAY(7) > [End Date]@row, "At Risk", "Not Started")))
-
Every 5th Value
I have a range that is 1 row high and twenty-some-odd columns wide. I need to AverageIF() some of the values in this field together, starting by looking at only every 5th column and then if they're not equal to 0. The 0 part is easy, as is setting up the AverageIF(), but where I'm having trouble is in finding a way to get…
-
Does "You can only reference a total of 100000 cells from other sheets." apply to 1 or all sheets
I have 2 sheets consolidating data from 2 source sheets. One of my consolidation sheets works fine, pulling data from both source sheets. The second consolidation sheet fails whenever I attempt to change the sheet reference in some cells to point to the second source sheet (which I was able to do on the first consolidating…
-
Project Health formula
I want to create a formula that accomplishes the following: If [Target End Date] is today or later or if [Actual End Date] is on or before target end date = Green If [Target End Date] is 1-3 days ago and [Actual End Date] is blank or [Actual End Date] is 1-3 days later than [Target End Date] = Yellow If [Target End Date]…