-
Formula Question
I am using this formula to calculate the % of budget used to date on a project: =[Actual Hours]@row / [Planned Hours]@row. Some of our projects do not have the planned number of hours. In this case the cell for planned hours would either be 0 or NULL and I would like the % of budget cell to display: "No Planned Hours…
-
Getting Outlook to Open After Clicking Email Hyperlink in Dashboard
Hello! I am making a dashboard and am using a Rich Text Widget to include relevant contact email addresses. All of the emails I included appear as hyperlinks in the Dashboard and the actual links include "mailto:" followed by the intended email address. The formatting is correct, however when I click on the hyperlinks…
-
Utilizing single form information across multiple departments
Hi everyone, I am pretty new to smartsheet and trying to work through some solutions for my organization. One of the current projects is utlizing smartsheet to talk across departments for intake information. Group A sends out a form for a customer to request information Group B wants to pull only some data fields from that…
-
Using HAS to search multi select column @ each row in a single cell
I'm getting the formatting confused here, I have a sheet where I want to in one cell search and identify whether a multi select cell contains a value and provide yes/no as a result. Team Name has a list of team names I want to search in to find a specific "Team". I want to look in line, having each subsequent row look at…
-
Count based on Multiple Criteria & Dates
Hi, I am attempting to create a formula that would = Count the number of training items completed per team member and between two dates. I created this formula, it is giving me all Zeros: =COUNTIFS([Actual End Date]:[Actual End Date], <=DATE(2024, 1, 1), [Actual End Date]:[Actual End Date], >=DATE(2024, 12, 30),…
-
Nested IF/CountIF Help
Hi! I am currently building a dashboard to show reporting on employee injuries for cases that are not resolved. I am having trouble with my formula and have been spinning my wheels. I need the formula to look at my reference data and, if the checkbox in the 'Done' column is not marked, then return the incident type into my…
-
Count number of tasks by day to know how many workers are needed
Hi Everyone, Brand new to smartsheet and I have very little understanding of it's capabilities. I've built an extensive gantt chart with tasks going out over a year. When I manually count the tasks, I can see that I need anywhere between 2 and 5 workers on a given day based on the number of active tasks. As I continue to…
-
Join Collect Function
Hello community, I am trying to collect all dates into one field when a presenters name is present. Sheet one has my presentations scheduled for 2024-2025 - (need dates pulled into sheet three) Sheet two has me presentations schedule for 2023-2024 - (need dates pulled into sheet three) Sheet three has all presenters I have…
-
How to match clinical trials to subjects based on eligibility criteria columns?
Hello, I have 2 sheets and I want to pull information from sheet to another sheet if certain criteria are met. The first sheet, "Slot List", is a list of clinical trials and the columns contain the study name and certain eligibility criteria patients need to meet to join the study. On the second sheet, "Trial Match", is a…
-
Formula not returning the correct values
I'm having a bit of a weird issue. I have a helper column that is supposed to return values that are pulled for a metrics sheet. Overall the formula is working, but it's like its not moving past the "Materials Delivered to Vendor" part. =IF([GM Status]@row = "PO Created", "Written", IF([GM Status]@row = "Delivered to…
