-
Formula
Hello, How do I enter the formula that counts the slots following the text "Total slots filled =" ? I want the calculation in the same cell with the text and not in a separate cell, plus I want it to count blanks.
-
Auto expand section of dashboard.
Is there a way to set a field on a dashboard to automatically expand to fit all the data? I have a report that shows the topics coming to a meeting in the next 30 days. This field will change often. Can the field be setup to move everything down on a dashboard instead of making people scroll or for me having to go in and…
-
How Do I Pull Data from Two Sheets to Summarize Output per Hour?
I'm working with two grid sheets that include various columns of information. Each has multiple rows of information. We have Smartsheet Pivot to help pull data together. Here is a simplified example: Grid 1 Columns: Ticket#, Footage, Value, Date Grid 2 Columns: Employee, Hours, Date I'd like to total the footage for a…
-
Percent Complete from an External Reference
Hello! I'm working on a project plan for work and have external references to another sheet. I'd like to accomplish a count or countif function to help me with the below: If "Column X" = "Y" then count the sum of "Y" in that column and divide it by the total rows for a percentage complete. Meaning, I want to count the…
-
Nested If Functions
I have been wracking my head over nested if functions. I seem to get the opposite of what is expected with a false answer being given when it should be a true answer! I have 4 possible responses between 3 columns that are yes or no. If the first column is no then the response should be no, if it is yes and the other two…
-
Edate formula
I want to calculate the contract expiry date based on the current contract term. If the day of start date <=15, the expiry date should be the last day of the previous month if the day of start date is the expiry date should be the last day of the current month any help would be great thank you
-
Sumifs, referencing another sheet with two conditions
I am trying to add numbers based on 2 conditions. I am referencing another sheet. I am using the following formula: =SUMIFS({FY21 AA AMER Budget US$}, {FY21 AA AMER Quarter}, contains "2021",[{FY21 AA AMER Marketing Cost Type}, contains "Content"]) I want to add the budget for AA AMER if the following two conditions are…
-
Trailing 12 weeks/months style report
I'm looking to create sheet that will roll up data for a trailing time period. I can collect the data easily enough, but of course, the data changes over time. Is there a way to collect the data, then freeze it and collect new data in a new cell? I don't have a problem pre-building the sheet with all of the future dates,…
-
Need to average a range within a certain month
I am trying to average a column that has its own set criteria and calculating it with in a month. I am separately doing these two formulas but now want to combine it. My first formula:. =IFERROR(AVG(COLLECT({time in days}, {hospital specialty}, "Acute Care", {job type}, <>"PCT")), "") This gives me an average time to…
-
How do I count cells that include a value and not just cells that only have a specific value in it?
I'm trying to count the amount of cells that have a value of "keys" included in it, but it's only giving me the cells that specifically only contain "keys". I want every cell that contains "keys" within any portion of it. Below is the function I've used. =COUNTIFS([Key/ Swipe/ Code Request]:[Key/ Swipe/ Code Request],…