-
Using COUNTIFS and NOT together
I am using the following formula and getting an error: =COUNTIFS({Master Discrepancy Log 2021 Owner}, $[Primary Column]@row, {Master Discrepancy Log 2021 Product Type}, "Prime Share", {Master Discrepancy Log 2021 Month Opened}, 2, {Master Discrepancy Log 2021 Year Opened}, 2021, {Master Discrepancy Log 2021 Discrepancyโฆ
-
Combinging two IF statements
Hi, I need help combining two IF statements. They are constructed the same, but I want them to be one entire formula for a specific cell rather than two seperate formulas. They both work serpartley, but I keep getting errors when trying to combine them. Essentialy, it is when the Department column is blank it willโฆ
-
Counting instances in each of the last 6 months on a rolling basis
Hello, I'm trying to count the number of times a type of dispute occurs within a month in the last 6 months in order to monitor trends. I want the months to roll so I don't need to adjust the formulas ever. My formula doesn't take the previous year into account and I'm not sure how to introduce it. This is what myโฆ
-
Formula to stop Date Countdown
Hi! See attached pic I have struggled with this formula and not had any success to get it to do what I want. Current formula is: =[DUE DATE]@row - TODAY() ...this gives a handy countdown. In the pic you can see the first line should not still be counting down as the task was completed 12 days ago. What I need it to do isโฆ
-
Help with formulas to have data in the Summary Sheet
Hey Paul, I have created the below individual reports for the upcoming tasks in the Smartsheet. This has a combination of Tasks + Country + Owners + Status. However, I also need this data in the Dashboard. Could you please help me with formulas to have this data in the Summary Sheet? So that I can pull the data from theโฆ
-
Matching data from one column in Project Intake Sheet to another column in Project Metadata
Hi so I am currently redesigning a project tracking system for a company. I downloaded the PMO template set to use to get a foundation but it will not track the data i need it to track. Basically what I need help with is I have multiple columns in the Project intake sheet that will have simple data put in them like datesโฆ
-
Change Past Date into Month as Written Text
Probably a simply question but I'm looking for a formula that is able to read dates in the past, and then fill a different cell with the month as text only. e.g. The first 'offline' date would populate the offline month with 'October' Thanks
-
Actual vs target Date
Hi, Need a help if my Start Date is 05/24/2021 and end date is 07/01/2021 and in my project plan sheet say i have a task that start on 06/24/2021 and end on 06/28/2021 .However, that task is already been completed and the actual % Complete has been updated to 60% for that task i want the schedule Health should be turn toโฆ
-
How to write below formula in smartsheet
Hi . Can anyone help how to write below formula in Smartsheet
-
IF formula with multiple conditions
Hi! I am trying to create a risk register template and would like to have the columns: 'Impact', 'Likelihood', and 'Risk Score'. The Impact and Likelihood columns will be user selected input from a drop down menu, where the options are 'Low', 'Medium', and 'High'. I would like the 'Risk Score' column to then populate basedโฆ