-
Metrics Formula
I am trying to find out how to do a formula that looks at the project manager and the various project statuses for each of their assigned projects. Ex. John Doe has 2 projects "in progress", 3 "completed"; 1 "not started"
-
How to track people Form completion
Hi Everyone, I have been thinking about this for a couple of weeks now. I want to bring my manufacturing facility to the next level by creating an associate monitoring database. Let me explain more. The Food Safety Team consists of 30 associates on my site. They are responsible for conducting Food Safety Audits (Smartsheet…
-
Why is Index Collect formula returning Invalid Value error?
I am trying to pull a project number from a source sheet into my current sheet based on the employee number and date column matching on both the current sheet and source sheet. Here's my current formula: =INDEX(COLLECT({Project # - MP Proj}, {Employee # - MP Proj}, [Employee ID]@row, {Week Start Date - MP Proj}, [Pay…
-
Sum formula with multi select option
Hi, I am trying to create a column formula that will add up the cell values to the left based on specific drop down. Point is given if they followed these areas. So, no point would be Safety Concerns (0 pt). =SUM([Following Policy]@row:[Delay In Patient Care]@row, =[Following Policy]@row:[Delay In Patient Care]@row) How to…
-
Using ISBLANK with a checkbox cell
I'm trying to create a formula for my sheet that is counting a total number of items in the sheet within certain parameters, I've gotten the formula down for most of them but where I've run into issues is that my final formula either needs to be based on a column that is a checkbox OR if another column is NOT blank. The…
-
Trying to add informtion from two sheets
I have two sheets with the same column and I am trying to write a formula that says to only count the cells that say "Red" in them. I got it to work with a single sheet but I need the total to be from two sheets, the current and the archived. This is how I wrote it but its not working =COUNTIF([REPORTING Screeners…
-
Formula Query
Hello, I want to feed a sheet automatically as we could do on Google sheet with the Query function. Is this possible with formulas? for example I want to highlight a whole column from sheet 1 in a new sheet 2 based on a criteria from sheet 1 Cordialy, azerty64
-
Why is the formula saying invalid operation?
I have a Smartsheet page that I am trying to pull data from between 2 dates. The formula below is the one I am using but it says invalid operation? =SUMIFS({Work In Progress - 2021 - Range 3}, =[Primary Column]@row, {Work In Progress - 2021 - Job Value Range 3}, {Work In Progress - Job Value Range 1}, <=DATE(2024, 3, 31),…
-
INDEX MATCH or JOIN COLLECT formula for multiple criteria's
Hello, I am attempting to take a previous intake from and update the new form will allow for more "automation". On the form the requestor/submitter selects a theater and region/country. Once the intake form is received the data in the sheet populates (based on formulas) the following: division, country, PRM, RPL, or SRM.…
-
Don't want to show the DataMesh Lookup Value
Is there a way to use the DataMesh Lookup Value (in this case an employee ID #) to match rows but not actually INCLUDE the Lookup Value on the target sheet (or at lease make it not viewable)? I want to share information on the target sheet with groups of people that are not in our department without sharing the employee ID…