I am trying to return a value to a cell, based on a date condition at the top of the column. For example, if there were 52 columns of the "week dates" in a year. The parameter for the return value is …
Hey folks looking for IF statement that would allow me to specify a number ranges from one cell that contains a number to then display the appropriate Arrow. Any help in changing the formula would be …
Hoping you can help! I'm trying to setup a formula where if I have a Red RYG ball in a cell of a task row then the comment next to it copies into a different cell (on the same sheet) for reporting. I …
I have the following statement and it works for the bold section but when I add the italic section I receive an 'UNPARSABLE' error. Thoughts? =IF(AND([From Calculator]2 = "<100", [From Calculator]4 = …
Hi All, I have a sheet that has been populated via forms for the past 12 months. What i would like to do is use a count if formula but only when the date is this year. my current formula is =COUNTIFS(…
Hi, One of my sheets has a master Parent and have several parents and childs below. What could be the formula to count all items below any Parent, which counts all parents and childs below? Thanks in …
I am trying to create a formula to count the number of projects assigned to one person based on the phase of a project. My criteria is that is NOT one of the following phases: Construction, Completed,…
I'm a smartsheet newbie and i'm ultimately trying to build a formula that automates task progress based on the following: If % Complete = 100, return Blue If it’s not scheduled to start yet, return Cl…
Hi All, I am in need of some formula help! 1. I would like to count all of the projects in my portfolio that are in the Active state and either Yellow or Red health. I have a Dropdown List column for …
Hi Again! Is it possible to create data that provides QTY of selections checked per week and record this on a sheet automatically with formula. So we are managing live installation projects, with a hi…
