-
Why is my COUNTIFS formula counting more items than necessary?
Hi all! I'm currently using the following formula (with references) to count the amount of items that fit a certain criteria (91-180 days, 181-270 days, and >270 days): =COUNTIFS({Age Grouping}, "desired amount of days") The formula works perfectly for the first two criteria, however, when it counts ">270 days", it returns…
-
Is it possible to have a column in a sheet serve as a reference to multiple other sheets?
Here is my scenario: I am redesigning some of my template sets and dashboards but leaving the originals up and running at the same time. I created a sandbox environment (workspace) to do this in. Some of the new sheets use the same data and formulas. Copy and pasting the formulas sometimes required me to recreate the…
-
Starting a New Multi Sheet Tracking System
Before I try to dive into this alone - I thought I'd ask for some recommendations. I manage a team of producers who each have a client pipeline. I need to have each producer track their pipeline list with some basic data (dates, closing agent, status, etc.) - so each producer would have their own sheet assigned. I would…
-
IF cell matches criteria in one column, THEN return other columns from matching row
Help, please! I am trying to search a MASTER sheet for ALL ROWS that match two criteria (MASTER Author-Partner matches the value in [Project1], and MASTER Project category matches Project@row), and then return the contents of certain cells within each matching row (Title/Topic, Product type, Status, Due Date). I have had…
-
Maintaining multiple sheets with the same format
I created a tracker that I then created 20 copies of and each one is used by a different team. The sheets all have the same workflows/conditional formatting. The business owner keeps wanting to make tweaks to the sheet (like to add a column or something) and it is very time consuming to do that to each individual sheet. Is…
-
Multiple forms to a record
Hi, Wanted to check if there is a mechanism wherein smartsheet can store the information collected via different forms at different points in time in a single row ? Providing an example below for more clarity - Lets say we break the client engagement (an enquiry -- lead generation -- service agreement) flow into multiple…
-
Activity log for certain user
I have noticed on log history that one user has successfully logged in. I have full admin account, can I check his activity since last log in ?
-
Copy folder error
I have created a folder containing 15 sheets with various links to reference sheets (outside of this folder) and datameshing. The idea is that I can copy the folder, change a cell reference (location) and the new folder will update with the reference data for that location. I've "saved as new" the folder and gotten an…
-
Help needed with averaging RYGB balls of children cells
Hi, I wanted to know how I can average the RYGB balls of the children cells. Something on the lines of if there is even 1 red, then turn the parent red. If there are no reds and at least one yellow then turn the parent yellow. If there are no reds and yellows, and at least one green, turn the parent green. If all the balls…
-
Auto fill information in sheet when a check box is checked in a different sheet?
Hi! I am trying to figure out how to auto fill information into my sheet, when I check a box in a different sheet. Essentially, all I want to do is autofill the check box on sheet 2 once it is checked on sheet 1. Is this possible?