-
Avg number of selections per condition
Hi there, I need some help. I'm trying to calculate the avg number of issues per condition in our master tracker. The issues are in a multi-value cell {Rev Rec Master Tracker Range 1} while the condition is a single-value cell in {Rev Rec Master Tracker Range 2} with values either as "Backlog" or "Net New". I'd like to…
-
Calculate Average Days When # is 0
Hello, I'm trying to create a formula where we track the days go from sent to actioned on. We have a column where it get's the number of days from sales sent to sales actioned on and that's simple a subtraction. However, when I'm trying to get the average number of days it takes a lead to be actioned on by month I'm…
-
Check box selection - referring multiple sheets
I have multiple sheets(sheet1,sheet2,sheet3,sheet4,sheet5) with email id's and I want to cross check in one master sheet in one check box column, if the match found then it should check the checkbox. can we use index match formula to refer multiple sheets? I'm trying to delete the master sheet email address if any of the…
-
Sheet summary for resources that I can track
So with my projects, I have a Project Manager field on each sheet. With that I can create a chart/data showing by project lead, how many projects they have. But within those projects, there are sub tasks that have assignees that I want to track as well as to the number of projects they are working on.. Is there an easy way…
-
VLOOKUP Help
I am trying to bring data in from another source sheet. This source sheet is updated as users submit forms. So when a user submits a form with new data, a new top row is created on the source sheet. I would like it to auto update my master tracking sheet. Is this possible with vlookup? The issue is I need it to be specific…
-
NETWORKDAYS function help
I am creating a column that calculates the number of days between the "Finished Date" column and the "Needed By" column. The original function was: =SUM([Finish Date]@row - [Needed By]@row) We want to include only working days (M-F) and exclude holidays from this count of these days. Sometimes the finished date rows will…
-
pulling distinct data to another sheet
I have a worksheet which I am working metrics on a separate worksheet. I have a list of courses on the main sheet and they can be duplicates. What I am trying to do is pulling those distinct courses onto another worksheet and I can use count how many times they are used for, but I need to pull that distinct courses from a…
-
Nested "if" formula
I'm trying to convert this excel formula to Smartsheet but can't find the right procedure. Keeps coming back as unparseable. =IF(J3=100%,G3,IF(J3<100,"")) J3 will always be filled in with a % and G3 is a dollar amount. Any help is appreciated. Craig
-
Can HAS formula be combined with AND?
I have multi select column - so I was able to do HAS to count all criteria in the column, but I also would like to count if there is a combination of two items in column as well - So let's say, I have a column called Course Type - i have four possible types - Self-Paced, Class, Video, On-Demand. So some courses have two…
-
Cross sheet referencing
Hi All, I hope you're well. I'm wondering if you can help me with my issue. We have a RAID log for all the issues/risks on our projects. On the log, they are being identified by job numbers. We also have our main master tracker with all the projects on it. On the master tracker, there also is a column named job numbers -…