-
Error with COUNTIFs and date formula
Hello! Can someone please advise what am I doing wrong getting this error? The formula used is as follows: =COUNTIFS({ref sheet}, AND(MONTH(@cell) = 1, YEAR(@cell) = 2021)) The date column in the reference sheet is set as "Date" and the format is DD-Mon-YYYY (e.g. 19-Jan-2021). I've tried creating a default date column in…
-
Report or formula to show time individual cell was changed?
We would like to be to see when (timestamp) changes are made to individual cells in a row without having to manually check cell history for the cell(s) of interest. Is there a formula we can use to do so? Or is there a report we can export to quickly be able to examine this data point without having to manually check cell…
-
Split a number using LEFT and Right Formulas
I have a location number that is 6 digits long. I am trying to create a formula using LEFT and Right to add a dash after the first 4 numbers. EX: if the location number is 123456, I want to create a formula to show 1234-56
-
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?