-
How do I use percentage formulas to breakdown responses
I am currently tracking a project and have 4 columns that use the following values - pass, fail - see notes, n/a, not tested. How can I break this down % wise to see which line items have passed, failed, n/a or not tested per column? The goal would be to roll the information up to a report then up to a dashboard.
-
Count Rows Where A Value in Multiple Columns is blank
Is it possible to count how many lines meet certain criteria AND have a blank value in Column 1 OR Column 2 OR Column 3? For example I have a Smartsheet with a questionnaire and am currently trying to calculate metrics from the answers in said questionnaire. One of my metrics is "Level 1 Completion" (which is equal to "Q1…
-
Help with a COUNTIFs Formula for a Date Range
Hello, I need a formula to count the number of times any date within July 2023 occurs within a set range of a column. This is what I have so far: =COUNTIFS([Date in Job]2:[Date in Job]76, >=DATE(2023, 07, 01),<=DATE(2023. 07, 31)) Thank you!
-
Lord Help Me!
Would appreciate some help with a formula! I ultimately need a column that either shows a count based on the difference between two dates, or a "0." In one column, we indicate whether a job post is open. "Yes" it's open, "No" it's closed. In another column, we show the date the job was posted. In another column, we show…
-
Date Summarization
Hello-- I've run into a puzzle that I cannot solve on my own. I need to group dates together by year to create a chart to show my leadership team. For example, I need all dates under Open 2021, Pending 2022, so forth. I've played with it for hours and I cannot figure it out. Any help would be most grateful. Thanks!
-
List distinct values based on a criteria and remove blanks
I am making a metrics sheet that calculates what I need to show from a datasheet. The datasheet has columns for the Type (building type is either MOB or Hospital) and Departments (MOB has 12 departments and Hospital has 24 departments) along with a bunch of other columns that have data. In my formulas {CD - } is…
-
Workflow for Past Due Dates
I need to create a workflow to send an email to someone when the Forecast Completion is past due, but I need it sent everyday until they update it. The condition is Where Forecasted Completion is in the past and where Complete Date of Build is blank. Trigger is when the Date in the "Forecasted Completion Date is in the…
-
Status Column Change to Record Date of Change
Hello, I am developing metrics for a group at my company and need some help. They do not log when they mark something as complete by date just by status. The date of the status change is in the cell history but I was wondering if there was a way to write a formula to show when a status is set to completed it records the…
-
Convert a Number to Word
Hi! I am using the document generator and need to convert a number to the word format of the number, ie. $56,235.16 would be fifty-six thousand two hundred thirty-five dollars and sixteen cents. Currently, I manually fill in the column for the word version of the number. Is there a formula that can calculate the number as…
-
Help with easier way to build dashboard for each year
I am building a dashboard that consists of multiple different reports that are all linked to metric sheets. In the formulas of the metric sheets, I have hard coded the year into them but I need to build this dashboard for every year and don't want to have to change the year in every single formula (there are about 5 metric…