-
Merge Cells???/ How to do this
I saw this article - https://www.projectwidgets.com/how-to-merge-cells-in-smartsheet/ however, I am not sure where these functions are at. Any help on how to merge data from multiple cells like they are referencing? do I need any add-ons. thanks in advance!
-
Join Formula with Dates - How to eliminate the time stamp?
I am using the join formula to combine the task name, start date, and end date into a single column that will be used for reporting purposes. The start and end dates are formatted to only show the date, not a time, however when I use the join formula, it's giving me 'Task Name -- ##/##/## 8:00 AM - ##/##/## 4:59 PM" and I…
-
Auto check all check boxes in a column
Hello! I have a sheet with a check box column where end users select the check box to nominate a speaker which will trigger a separate workflow. The issue with individually selecting is that there can be upwards of 100 speakers on the list. Is there a way to have an option for the end user to click one check box or choose…
-
Stacked formula, Data, Symbol and if blank
Hi, I am trying to write a formula saying: If blank then blank If Status column has "Full" symbol Progression to Completed Date column is "Green" Or if Completion Date is greater than today is "Red" Or if Completion Date is less than 7 days is "Yellow" otherwise is "Green" So far I have this, that is working well for…
-
CountIFs using multiple criteria
I want a count of the number of tasks that are complete. I don't want to include anything marked as not applicable or any headings (Hierarchy=Grandparent or parent), and it is counted as complete whether it completed by Medhost or by facility. =COUNTIFS([Not Applicable]:[Not Applicable], 0, Hierarchy:Hierarchy, "Child",…
-
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.
-
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!
-
Invalid Data Type on an IF function with Index Collect
Hi All, I am trying to nest and index collect into an IF but I keep on getting Invalid Data Type. =IF(INDEX(COLLECT({Tracker - Range 5}, {Tracker - Range 2}, [Project Name]@row, {Tracker - Range 5}, "LATE"), 1), "LATE", IF(INDEX(COLLECT({Tracker - Range 5}, {Tracker - Range 2}, [Project Name]@row, {Tracker - Range 5}, "On…
-
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…
-
Adding multiple SUMIFS and return is $0 if one cell is blank
I'm trying to add multiple sumifs formulas together in one formula. However, not all of the sumifs will have an input. Example: Expense tracking, most of the time there will be only one charge code to utilize. There are times when multiple charge codes can be utilized and I'm only trying to extract the amount for a…
