functionality
Discussion List
- Hi everyone, I am looking to combine two formulas in one cell (one to calculate number of days; one to calculate completion date, using calculated days). The information below was provided to me by my…
- Hi there, I've been reviewing past topics but haven't been able to get those formulas to work. I have a sheet where there are start/end dates, and a completed check box column. I'm having trouble figu…
- My =IF(Child@row="Name1", "Parent1") and it worked to bring the Parent name into the @row, but I am trying to also add a few other Child/Parent combos into it as well. For example, In the Parent Colum…
- 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…
- Hello, I'm looking for a formula to pull a date that is 90 days earlier than our start date but on the closest Tuesday. Thank you
- 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…
