-
COUNTIFS/OR/CONTAINS
Hello all I am trying to create a formula to imitate the following filter login in another sheet i am trying to pull a single figure via a countifs function from 5 different columns if any one of the 5 columns have a yes, that would count as 1 can anyone advise how i can pull this please ? @Paul Newcome @Genevieve P. your…
-
Formula Assistance
Formula Gurus - I need a formula that can be applied as a column formula in my column named Actual Duration (Days). IF the row is a PARENT row, the formula should return the sum of its children rows. For NON-PARENT rows, the formula should calculate the days between the Act. Start and Act. Finish columns. IF there is an…
-
Formula returning "invalid column value", but it looks correct.
I used the AI formula generator in Smartsheets and I'm still getting an invalid column value error. I can't figure out why because there is data in the column. If the IMP/DISC column displays Implementation then I want the value from the Implementation Status Update Date to show. If the IMP/DISC column displays Discovery…
-
Need Help with Task Health Formula
Hi - I'm trying to write a task health formula with the following criteria and am hoping someone can help. Here's what I'd like it to calculate: BLUE (NOT STARTED): If the start date is in the future and if the % complete is 0 GREEN (ON TRACK): If today is less than 50% of the task duration and % complete is more than 50%…
-
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))
