-
SUMIF condition
Hi guys! I have to calculate average in my sheet and I will use: SUMIF / COUNTIF - COUNTIF formula is working. - SUMIF formula is not working, i am getting #INVALID OPERATION The SUMIF formula is (screenshot attached) =SUMIF([Assigned to in Region]8:[Assigned to in Region]136, "Sarah Mabiletsa", [Quote Prep Cycle…
-
Can you assign muliple resources to a task without duplicating the row?
Currently, I am having to list the same task on muliple rows to assign different resources to them. Is there a way to assign mulitple resources to the same task without having to duplicate the tasks over and over again? There is a lot of repetitive content that is doubling the size of my Smartsheet.
-
Build Report for Group of Users
We have a number of User Groups.. some users overlap groups, as many of us wear a few hats. I'd like to build reports that run through the "ZZZ Workgroup" and look for lines that are assigned to anyone in "Group AAA." Perhaps also reports that pertain to "Group BBB" and "Group CCC" Yes, I could select each person in the…
-
Using smartsheets as a CRM
Hi everyone, In Smartsheets, I am trying to create a contact data base with a status trigger from a drop down menu... when "Lead Status" changes from "Lead" to "Opportunity" it triggers a bunch of actions I have set up through Zapier to set up the next steps, files, folders, etc. in Smartsheets and GSuite. Does anyone know…
-
How do I find a smartsheet expert for hire to help build out our workspace?
I am building out a new workspace for some large marketing intergration projects. I am way over my head with smartsheets, but I have used it to complete amazing M&A sheets. I want to start intetegrating smartsheets into the operating side instead of just the due diligience side of the business.
-
Drop Down List Selections
Can I build a drop down list that allows multiple choices to be selected?
-
Formula Query
I'm at a loss for how to perform a desired calculation within a sheet. I have a list of rows that are assigned to owners (contacts). Each row has a % complete. I want a formula that will tell me what a given contacts overall completion rate is. * Look up name in Owner column * Add up all percentages in the "% Complete"…
-
Generate list of recently updated sheets
I would like to have a quick readout of the five or ten most recently updated sheets from WorkspaceA or WorkspaceA --> Folder5 I can build a report that grabs all of the sheet rows by updated in the last 30 or 60 or 3000 days, but how can you get a list like: * FinanceSheetXYZ updated Yesterday by John Smith *…
-
USERS/COLLABORATORS
Why we have a Business plan with 100 users/collaborators and the system is asking me for more licenses when sharing a Workplace with few peoples. Our Business plan has 3 Licenses. account wj@toperbee.com
-
Mutiple Contacts / Update Request / Form
Hi All, I have a column that has multiple contacts. I'd like to send an update request or form to each contact in the cell but I don't want one contact to overwrite another contact's information. I want to capture the information from ALL contacts in the cell. Questions: 1) Form or Update Request? 2) Is it possible to have…
