-
"Filter" by Hour and Minute in addition to day(s)
Hello Smartsheet Community! I have a question. We are setting up a dashboard to display who is on call for specific regions. For some of the regions their on call is easy as it is always Midnight to Midnight but for other they weirder shift times (and people sometimes work "half shifts"). I have my reports for each region…
-
Counting each of the values in a multi-contact field
I have a primary sheet where team members are dropped into a contact column if they're working on a project. So the Contact column for any given project row might have one contact or three contacts in it. Then we have a project status column. Example... (Project Name Column | Team Contact Column | Status) Project 1 | Kate…
-
Creating Column with fomula using Control Center returns UNPARSEABLE
Hello everyone! I am running into an issue when using Control Center to create new columns with formulas across my active projects. I have already tried the column with the formula in one of these sheets and everything works fine there. However, in testing and creating the columns using Control Center, it returns the…
-
How do I return DISTINCT values from another sheet based on specific dates within that sheet?
Hello, I have a need to return a Distinct Item ID from another sheet based on a date range from another date column within that same external sheet. The formula below works; however, once I run out of Distinct item IDs that meet my date criteria it continues to return results that fall outside that date range. Current…
-
@row referencing cell above
Is there a way that I can use @row to reference the cell above? I'm creating a formula to check for duplicates and I want to compare details in the current row to the one above.
-
Formula to remove zero on metric sheet
Hello - I am using a metric sheet to pull together a Dashboard of information. I am pulling from a larger sheet into the metric sheet and then importing the data into a Dashboard either as a chart or metric. The data I am pulling changes every month and I want to simply total what is being processed each month. Some months…
-
Need Help with Formula to Roll Up and Average Schedule Health.
Need Help with Formula to Roll Up and Average Schedule Health. I have one that now updates the Schedule Health RYG based on the Start Date/End Date and Task Status. Next, I am trying to roll up/average those Individual Task schedule health values to an overall Phase schedule health value and then ultimately to the Overall…
-
Need help on Formula
I am writing this formula in column to calculate the Quarter (Q1,Q2,Q3,Q4) from a date and getting results like (Q1,Q2,Q3,Q4) without the year. Can someone please help me with getting this value Q4 - 2022, Q1- 2023 , Q2 - 2023 etc. Thanks in advance! =IFERROR(IF(MONTH([Reporting Start Date]@row) < 4, "Q1",…
-
Cell Value Capture for Monthly Reporting
Hello, I am trying to build an executive summary dashboard and would like to capture cell values at the beginning of every month to compile on a monthly basis. I have thought about using a row copy automation however i need to build a "capture sheet" for the dashboard to reference for several data points (total invoice…
-
Creating a count for a Column
So I have a column I am trying to get a count of by year for a Metric dashboard. I am using the following formula: =countif([Completion Date]:[Completion Date], ="2023"). This formula is not working and I am not the best with them. Can someone help me figure this our?