-
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…
-
Checkbox populated another column with date
Hello I have a checkbox column that I want when checked to copy the shipped date form one column (Shipped Date) to another column (Customer requested date). Is this possible with a formula?
-
CountIF where cell contains specific word
Hi I've read a few posts and dicussions but still can't seem to find an answer that I can use. I'm collecting data and have some basic dashboards setup which display the number specific words are recorded. As an example: Clinical Clinical Lead Clinical Specialist Lead Operational Lead I need to be able to count how many…