-
Count If a specific department answered "Yes" at least once
Good Morning! I've created a conflicts of interest survey and I'm looking for a formula to then reflect on my dashboard for reporting. Can someone please help me identify how i can use a formula to count if someone from a particular department answered "Yes" at least once within 5 questions? My point is to count how many…
-
Mass Attachments from Sharepoint Online
I am trying to figure out if there is a way to create attachments from Sharepoint URLs in mass. I have thousands of files saved on Sharepoint that have a standardized URL path and naming convention that is derived from values in my Smartsheet table. For example, I have 3 fields: Name State Year Test1 GA 2020 Test2 FL 2020…
-
IF Multiple values selected THEN VLOOKUP and return values
Is there a way to return values in a cell if multiple criteria is met? I would like to track the amount of time our Onboarding Coordinators spend on tasks for each Country. So when they create a contract in Austria it takes 60 minutes but for Croatia it takes 50 minutes. For a contract to take 60 minutes, date fields…
-
How to pre-populate empty cells.
Because I haven't found a better place to say this, and because a great deal of this has involved Formulas etc., I wanted to express my gratitude to this community. I'm not usually a community guy mostly because I feel intimidated. But what I'm trying to put together for my company has been important enough I was…
-
SUMIFS with sheet references.
Hello, I've got this formula working like this. =SUMIFS({DayCount}, {EmployeeName}, [Employee Name]@row, {ReasonforAbs}, "Vacation") However when I change the criteria to "PPL / Sick" it's returning 0 when there are clearly cells to count. =SUMIFS({DayCount}, {EmployeeName}, [Employee Name]@row, {ReasonforAbs}, "PPL /…
-
Last 7 Days Formula
I am trying to calculate how many IT tickets have been moved to the status of "completed" within the last 7 days. The formula returns a value of 6 but when I use the filters on the report, it returns the correct value of 2. Can someone help me with the formula so it returns the correct value of 2? The formula I have is:…
-
Forecasting Data for Event Revenue
Hello, I'm looking for a way to project future event revenue projections in a dashboard. If I had revenue from Q4 and Q1, is there a formula to forecast Q2 data similar to excel? What formulas have you used before? Thanks!
-
Friendly Reminders
Hi there, I have two troubles with the tool, I hope you can help me and I'll grateful for that First: I'm automatizating my process with friendly reminders, but these one e-mails their looks like a spam e-mails, I mean, the vowels with tilde doesn't recognize it and show a question mark in that space, this action it's…
-
How to add multiple values when creating a chart/graph?
How I can pull data from a cell with multiple values to create charts/graphs? Currently, the graph only shows/captures single value from the cell and not the other one. Is there a way around how to get this done? For example, when i am trying to build a bar graph for the values under "Hiring Manager" on row 5 -the second…
-
Auto number
I have a spreadsheet where i keep track of all the samples that we've sent for laboratory testing. They all have a despatch date and the lab that they are being sent to. Is it possible to set up the Auto-number system to generate only one number for all the rows with the same lab and date? The goal for this is to create…