-
Cross Sheet Reference Limit
Hi guys, Can anyone tell me if the same referenced field is used in more than one formula, is the reference counted as 1? I've mixed out my references and wondered if there's a way to reduce the number of unique connections.
-
Replace Cell with the Value of a formula
A common workflow for me while preparing data, is to use a formula to setup some cells and then to copy and paste the Values back into the same cells. Excel allows you to copy, but to paste just the values. (NOT the formulas). Can this be done in smartsheet?
-
Is it possible to update a contact list column based on a value in another cell?
Is it possible to update a contact list column based on a value in another cell using a formula? I am creating an assigned to contact list column with an end goal in mind of setting up a dynamic view based on setup specialist (my understanding is you can only set a user view based on a contact column). As you can see - I…
-
I want to count the number of times a contact appears in a column, how do I do that?
So, I started with =COUNTIF(Name:Name), FIND("John Smith", @cell) > 0) this produced #unparseable. My ultimate goal is to have a dashboard that will display a pie chart with total number of leads per person. Thanks for any help!
-
Making Negative Numbers Display as Zero
I am trying to calculate the number of working days between the due date and date received on a contract deliverable. The formula works great when the contract deliverable is received on time or after the due date. The problem I am having is if the contractor submits the deliverable early (prior to its due date) it is…
-
Is there a way to write a formula to uncheck the box in one column IF another column has a checkmark
I am wondering if there is a simple formula that will uncheck a box in one column if a second column is checked. I am sure it is a really easy formula but I am drawing a blank. Thanks.
-
Need Help with Duration (days)
Hi guys, I am setting up a dashboard and trying to collect data for it. I would like to show average duration for projects, if possible. For example, I have the columns below. Is it possible to create a formula that will tell me an average length from received to approved? Or do I need to add an actual “Days” column into…
-
Help needed with formula calculating open issues based on status, owner and due date
The formula is not pulling all data. Below are the formulas I am using: Overdue: =COUNTIFS({Status}, "In Process", {Assigned to}, "Susan Hacker", {Current Completion Date}, <TODAY(0)) Due in 1 month: =COUNTIFS({Status}, "In Process", {Assigned to}, "Susan Hacker", {Current Completion Date}, <=TODAY(30), {Current Completion…
-
Formula to indicate previous and next months
I'm drawing a blank on how to achieve something to avoid having to manually maintain a sheet. I've got a main data sheet with new requests getting populated. They have dates associated with them and what I'm doing is pulling them into another sheet to summarize that data based on the month. This piece is working great with…
-
COUNTIF / HAS / AND - How to count multiple selections in the same column.
Hello to All, I am trying to count items in a column. I have the formula in place for all inpatient and another formula for ambulatory. I need a count for those that have selected inpatient AND Ambulatory, basically how many selected both locations. This is what I have tried: =COUNTIF(Location:Location, HAS(@cell,…
