I need to tweak the following formula to use a [Status Date] instead of "Today". We publish status reports each Wednesday as of Friday of the previous week. I have added a Status Date column that I wi…
Hi there, I currently have this formula (below) for my checkboxes that states if the end date is less than 30 days away and the Status of a project is "In Progress" the checkbox is checked off. Curren…
Hi, I want to pull the SEVEN MOST CURRENT ENTRIES for each QUESTION for each LOCATION. Here's my Master Smartsheet. This is the formula I started using based on responses in the community: =INDEX({TES…
I have a sheet that our PMs approve invoices and another sheet that copies the rows as soon as they are approved. One column is Date Created (Created Date) and the other is Approved Date (Modified Dat…
I have a sheet that bring in once a week that has our available units and extra data. I need a report to look a this data and return a count of how many units per building are available. Data coming i…
I am trying to create a RYG formula Have a drop down column with the choices: 75% staffing 50% staffing 25% staffing <25% staffing I want to say that IF([Staffing Level Impact to MEF]@row = "75% staff…
Why am I getting no errors, but a 0 (expressed as a percent as formatted) when using the following formula? Please note that I am NOT the person who named these columns or the list of values therein, …
Hello, How do you average column and not include the cells with zeros in them. Value 1 Value 1 Value 1 Value 0 Value 1 This column will grow larger and larger as more form data comes in. Thank you
I need to write a formula to count the number of projects in a sheet but subtract all projects that are tagged (checkbox column type) if the cyclical column is checked. Does anyone have any suggestion…
