-
COUNTIFS on 2 check box columns, 1 checked, 1 unchecked
I am trying to write a formula for a sheet summary where an "Over Due" check box is checked (driven by a due date column), and a "Done" check box is not checked... =COUNTIFS([Over Due]:[Over Due], 1, Done:Done, 0) #Invalid Operation... I originally tried to run a countifs based on Done = 0, and Due Date < TODAY, but…
-
Enhancement Request: Allow "when condition is not met" for Date columns
In order to do some common date related conditional formatting (for example, aging or older than 7 days ago https://community.smartsheet.com/discussion/setting-conditional-format-when-date-eg-more-week-ago), we need to create a formula. This could be avoided if we had the same functionality for dates that we have for other…
-
Checkbox and IF statements
Hello having trouble creating a formula and not sure if it is possible So I have two sheets first with 5 check boxes and then a value field. The second which holds the values. I want to be able to check the boxes and then have the value field add up the total example Sheet 2 values = These values might change over time…
-
Count projects that will complete in the current month - parent rows only
I have a sheet that houses all projects within one department. Many of the projects have child rows that I don't want to include in my count formula. I have a Hierarchy column that reflects "0" in the parent rows - those are the only rows I want to count if the date of completion is in the current month. Help? Thank you!
-
Formula Help!
Hi there, Would someone be able to help me with a formula that would be able to calculate the Fiscal Year based on a Finish Date of a project? FY19 - Feb 2018 - Jan 2019 FY20 - Feb 2019 - Jan 2020 FY21 - Feb 2020 - Jan 2021 Thanks so much!
-
COUNTIFS and/or IFS help needed
Here is my situation: I have a PMO tracking sheet that is tracking many projects through various statuses. I am putting together a metrics sheet so I can create charts to put on a dashboard. In the metric sheet I am trying to count the number of projects by department where the status is not Complete or Cancelled. I can't…
-
Formula Help - Countif in Multi-select column
Hello - Two formula questions: 1. I am trying to input a countif formula into a Summary field that will count how many times the name of a specific team appears in a column that uses a multi-select dropdown. This column also has some fields that are blank. Below is what I have tried and am receiving an 'Unparseable' error.…
-
Taking a dashboard "snapshot" as a pdf and attaching to a given row
While the header of my question seems confusing, hopefully an easy solution exists somewhere. I have a complex smartsheet's dashboard created which has metric widgets filled with values that update every time a new form is submitted to a sheet ("sheetX" for later reference). What I want to do is try and capture a part (or…
-
% Complete Parent Row
I just started using Smartsheet and I was wondering if someone could help me. I want to basically calculate the % complete, as the dependency setting does for you automatically. However since I entered a formula in my % complete column (if status is "done" then automatically give 100%, if status is "in progress" then…
-
Counting current months in a date column
Hello, I am trying to get a count of due dates in the current month, here is the formula I am using and it always returns zero. the formula is in a text/number column and the data is in a date column. =COUNTIF([Due Date]3:[Due Date]204, MONTH(TODAY())) I,m a beginner and could really use the help. not getting errors, just…