-
Task that lasts the duration of the project
I have a task I want to track that lasts the duration of each project. However, since the start/end dates can't be formulas, I'm wondering if there's another way to set this up in my template?
-
Grid help needed to reference different POs with changing totals?
Greetings- I created a SS for my finance dept. Basic form where they can select a vendor from a drop down menu and enter that month's bill with what they paid. Each vendor has a different PO number with a different total amount on that particular PO (purchase order). Im having trouble figuring out how to start with a PO…
-
I am looking for creative ideas on how to create a gap analysis
We are currently in the process of assessing our skill proficiency levels, ranging from Level 1 to Level 5. To visualize this, I've created a heat map that illustrates our current skill landscape and the proficiency levels we possess as an organization. As part of our strategic approach, we are now reaching out to external…
-
Multiple IF Statement Returning Different Text
Hi Everyone, I am trying to write a formula that will look at a cell and if certain wording is not in the cell then return a value to a new cell. The information is from a multiple dropdown selection column. Here is an example of what i am trying to do. Dropdown List Would Populate the Missing Color column based on a…
-
How to count values if either of two conditions are true
I have two sheets: Sheet A and Sheet B I would like to count the number of cells in Sheet A, Column A and Sheet B, Column B that have the value "Liver". Both sheets are stored under the same folder.
-
Moving from 2023 to 2024
In 2023, our data was recorded by regions which then produced a President's report and Dashboard. Beginning in 2024, the data will be recorded as one company and not by regions. My sheets were originally set up with the help of a Smartsheet Professional so I am not sure how the formulas in the background are set up and how…
-
I need to count the number of enquiries between the dates 01/01/2023 & 31/12/2023
I need to count the number of enquiries between the dates 01/01/2023 & 31/12/2023 Just can't get the formula right, keep getting Invalid or Unparsable, I know it should be straight forward but...currently trying to use COUNTIFS I have the formula to count all the values that equal enquiry but can't set it to select between…
-
IF formatting combined with a calculation
I am trying to include a calculation only if a certain qualitative value is met. Trying to have the column indicate "Days Over Deadline" by subtracting the "Submission Deadline from the Submission Date," but only if the "Assessment Stage" is Issued. =IF([Assessment Stage]@row)="Issued", =SUM([Submission Date]@row) -…
-
IFERROR + IF/ISBLANK
This formula is almost perfectly pulling downtime by examiner and production date: =IFERROR(INDEX(COLLECT({downtime - downtime}, {downtime - production date}, [Production Date]@row, {downtime - examiner}, Examiner@row), 1), 0) There are a few records that are not in error, but the result is a blank, however, I need those…
-
Where do I put the IFERROR function to correct for year?
I have a column of dates. New rows are being added over time. I count how many occur in each month. In a separate metric sheet, have 12 formulas, 1 for each month, that look like this. =COUNTIFS({Date Column}, IFERROR(MONTH(@cell), 0) = 1, {Date Column}, MONTH(@cell) = 1) for January =COUNTIFS({Date Column},…