-
Add Summary Value from Sub Tasks
Hi all, I have a project tracker that has been created from a project template then manipulated. The template was pre-programmed to calculate/populate the summary value for the Preparer % Complete column but I would like the Reviewer % Complete column to have a Summary Value as well. Is this possible? Thanks in advance!
-
Trying to apply an AVERAGE IF formula
I am running the Employee Pulse Check template for a project survey for our installer team. In a nutshell, form submitters will use a drop down to select which installer they had for the project, and then rate them on 5 questions. I need to average out the ratings for the 5 questions, per installer. Columns I would like to…
-
Automated Workflow - Move row to Sheet (with Index Match Formulas)
Hi there, I have a automated workflow where I have multiple source sheets copying rows into a separate sheet. Since the copied row information on the separate sheet can change on different columns, I have a Index/Match set up to auto populate any changes from the source sheet. The problem I'm having is there is another…
-
Count special characters in a cell
I'm wondering if it's possible to count special characters in a cell, created from a cell formula Count String Occurrence in a Cell — Smartsheet Community What I'm currently doing is adding a period to a JOIN(COLLECT function which I am counting the periods. See below: =JOIN(COLLECT(Post$1:Post$300, [Position…
-
Need help with a master report to create conditions within a calendar.
I am trying to create a master report where it shows vacation days for the team as well as due dates for the projects they are working on. With that being said, I would like for the start/end date to show on the calendar for vacation, but ONLY the end date to show for the projects since they are usually pretty long…
-
Formula for checkbox when date is previous month (and considers previous year in Dec)
How can I alter this formula so that in December of each year, it only considers December of the previous year? As it stands, it's pulling in Dec '22 data. I only want Dec '23. =IF([Payment Date]@row = "", "", IF(MONTH([Payment Date]@row) = IF(MONTH(TODAY()) = 1, 12, MONTH(TODAY()) - 1), 1))
-
COUNTIFS with multiple contacts in the same cell then reference a second column
Hi, =COUNTIFS([24-7 PM]:[24-7 PM], HAS("Jon Cornwell", @cell), [Project Type]:[Project Type], "LV Switchgear") I am trying to create a summary which shows how many of a certain project type a project manager may be involved in. Hope that makes sense I can get the first part of the formula to work on its own..…
-
SUMIF ?
Can someone help with the correct formula for the following: I need the JO Volume column sum if the PO Forecast Month column is marked 01-January. Below is what I have so far, but it is not working. I appreciate the help - thank you! =SUMIF([JO Volume]1:[JO Volume]40, [PO Forecast Month]1:[PO Forecast Month]40,…
-
Formula help for previous month
I have a helper column for a report that I want to check the box if the DATE cell is in the previous month. Any help is appreciated!!
-
=OR(ISBLANK Formaula
Hello, I am trying to build a =OR(ISBLANK formula into a text box column. Check will display is any cell is blank. I have the following formula but is displaying #INCORRECT ARGUMENT SET. =OR(ISBLANK([Producer Code(s)]@row, ISBLANK([Servicer AM/AE Codes]@row, ISBLANK([SIC Code]@row, ISBLANK(FEIN@row, ISBLANK([LOB’s to be…