-
Median & Sum of Multiple Columns in Date Range
Hello, I am attempting to write a formula to display the median of 6 columns, only if they contain data within the last 7 days per the date column. I also need to display the sum of the same 6 columns if they contain data within the last 7 days per the date column. I've tried what seems to be an endless variety of formulas…
-
IF, IFERROR, SEARCH nested formula help
Hi team - Looking for help in either fixing the below formula or creating a new formula. Goal behind the logic: Be able to use this cell to confirm if another column,same row (Level) has the abbreviation "Mgr." If it doesn't add a dash "-", full stop. If it does, we need to search another column,same row (rep region) for…
-
SUMIFS Question for adding a criteria for a column sum function
Hello! I am working on creating a travel budget dashboard for my team. I threw in some random numbers but essentially I am creating this data sheet to reference my main sheet where I house all travel budget requests. In my other sheet I treat as a data repository of all requests I receive. The above {cost} and {Dom or Int}…
-
Health Status/Rating calculated by Removing Specific Task names
Hello Smartsheet Community, My team and I are looking to improve a formula that helps to roll-up a score/health status of all of items within an activity plan, which is our RAID Log (Risk, Action, Issue, and Decision). We have a formula that calculates an aggregation/overall rating of all of the risks we have identified,…
-
Need help showing child row statuses in parent row status
Hi! I need help creating a formula that shows the child row statuses in the parent row. Is the below possible to build into a formula that I can pop into the parent row? Show “Not Started” if all child rows say “Not Started” Show “On Track” if any of the child rows say “On Track” Show “With Client” if any of the child rows…
-
IF CONTAINS INDEX MATCH Formula
I would like to be able to create a report where I can see Activity A, Finish (of activity A), Report A, and Finish (of Report A) in separate columns. I don't want to use group functionality in Row Report as it becomes messy when pulling it multiple activities from 50+ sheets. Hence, I would like to create two additional…
-
Possible to copy data to cell if only one of multiple columns contain information
Greetings, Is there a formula that can be used to copy the text from a range of columns only if there is information in that column? For example, I have Columns [Name A], [Name B], [Name C]. Only one of these columns will be filled at the any time. If one of those columns has information, copy that information into Column D
-
SUMIFS question regarding multiple criteria to summarize a cost column
I have two sheets I am using, one is my master sheet where I am collecting this information via form I created and the second sheet is what I like to call my data sheet. I got the formula down for if it's domestic or international, then calculate the sum. That's perfect. But I am trying to further break it up by month and…
-
Formula for determining whether a date occurred during daylight savings or standard time
I've got a sheet that I'm using to track the go live dates of items for a project I'm working on. These always go live at 10:00am in my local time (PST/PDT). The go live timestamps for these items need to be entered in UTC on the backend, when means the times need to be entered as 18:00 if the item's go live date is during…
-
Display Chart of Count per date
HI I have column for End Dates and Rows for Projects. I want to show in the dashboard a chart that woudl show # of prject per end dates. Can you help?
