-
Help on IF Formula - Multiple Statements
Hi! I need some help on a IF Formula statement. On my sheet, I have a column that is using this equation - =IF([Total ALL Athletes and Unified Partners]@row = 0, "0", IF([Total ALL Athletes and Unified Partners]@row <= 5, "1", IF([Total ALL Athletes and Unified Partners]@row <= 74, "2", IF([Total ALL Athletes and Unified…
-
Formula help, please!
Hi Smartsheet Wizards, I need to create a formula for all assets completed in the fiscal year, by region - I have created the formula below and it works perfectly, but now I need to narrow it to count just a subset of asset types (from a multi-select column). I can add a single content type and the formula still works, but…
-
Combine formulas (parent & child rows) to use Column Formula feature
I'm hoping this is possible. I'd like to change our current formula in the Retired column (checkbox column) from being different for the child row and parent row to one formula that will allow me to change the Retired column to a column formula column. Here is what I have currently: Parent Row: =IF(COUNT(CHILDREN()) =…
-
Cumulative Expense Column for budget restraint checks
Hello I need to have a running total expense column on my smartsheet for budgetary checks. Can someone help me with a solution please? I would like a column that updates with a cumulative $ after I enter an expense amount in another existing column. Thanking you in advance. Lawrie.
-
How to Calculate number of months from Today to an End Date
Is there any advice on how to calculate the no. of months between Today and an End Date (mostly likely not in the same year)?
-
SUMIFS one of two names found
If Team One OR Team Two are found in the 'Team' column, add up the values found in 'Story Points' column. This formula gives me an error: =IFERROR(SUMIFS([Story Points]:[Story Points], OR(Team:Team = "Team One", Team:Team = "Team Two"), [RezW#]:[RezW#], [Week#]@row), "nope") The formula below works fine for a single team…
-
Formula with TODAY()
=IF([Finish]3) < TODAY(), "Red", IF(AND([Finish]3 >= TODAY(), [Finish]3 < TODAY(+7)), "Yellow", "Green")) is giving me a UNPARSEABLE error. Any suggestions?
-
Is there a way to have a flag automatically turn red if a Priority column is "A"?
-
Need help calculating Time (New to Smartsheet Formulas)
Hi all - I've searched and read through various questions/ responses regarding Time calculations and have come to the realization that I need help. I have a Start Time and End Time (Start & End of Trainings) - I used a dropdown from 07:00 to 23:30 (We typically train within business hours 8a-5p EST - but every so often…
-
Duplicates
Hello ~ I am creating a couple columns to be able to identify duplicates with Name entries and Job Posting entries. However, when creating the formula for the "Duplicate" column I see that it is not flagging the duplication. I believe it may be in the way I have written the formula and was hoping for some guidance.…