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)?
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…
=IF([Finish]3) < TODAY(), "Red", IF(AND([Finish]3 >= TODAY(), [Finish]3 < TODAY(+7)), "Yellow", "Green")) is giving me a UNPARSEABLE error. Any suggestions?
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…
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.…
Our organization works in a Fiscal Year Model (Q1AprMayJun Q2JulAugSep Q3OctNovDec Q4JanFebMar). I have a metrics sheet with a few YTD and Year Over Year calculations that leverage the YEAR parameter. Is there a simple replace that's recommended so that the formulas look for any particular year using the fiscal year? I'm…
Hi All I'm looking for inspiration on creating a formula on separate sheet looking at data and dates from another. For this example, I have left on one sheet to demonstrate. I essentially have to complete all my projects 10 working days before Bom S Date starts and if not I need to flag up the QTY of projects and which…
This one is baffling. I have a problem with 2 sheets reading each others data through a Vlookup. Each sheet has Vlookup ranges from the other sheet. I understand why formula and Vlookup may return a #circular or #blocked reference, but I don't understand why my sheets work perfectly for periods of time, and then start…
Hi there, I'm working on testing quality assurance of products sent to my company. For each row in my Smartsheet represents one product I am testing. Each row requires testing on 160 samples. In my reports I want to show the "Result Summary" column where if there were no nonconformities, then it would show up as "160/160".…