-
Locate/Find COUNTIFS
e.g. =COUNTIFS(Recruiter:Recruiter, "Christie", [Deal Date]:[Deal Date], MONTH(@cell) = 10) e.g. = 50 This is an example of how I identify my "deals" for the month in a sheet which lists every deal my company has made. The sheet contains thousands of lines. Is there a way to search/locate/find or highlight these 50 deals?…
-
Cheery picking data from a sales sheet for customer to view
Hello, We maintain orders for customers in a sales sheet, the columns look something like this; Order Number Customer name Description Manufacturer Order Status Ship Date Delivery Date Sales Value This is our master sheet. So to update our customers we have to look at the sheet and email them important information from it.…
-
Sheet to sheet selective data transfer (for new rows)
I currently have two active sheets. The first sheet, we'll call "intake" and the latter "Projects". If I review a *new* row added to "intake" and determine I want to copy it over to "Projects", I need selective data from certain columns on that sheet to transfer to certain columns on "Projects". The columns do not directly…
-
Cell Linking for Updates?
I'm trying to find a solution to reduce the number of updates my team and I have to do. We currently use Smartsheet to create and manage project plans but also have a master "Status Sheet" that lists all projects, their current task, and the deadline of this task. Whenever we update the project plan, we also have to update…
-
How to auto-refresh the datamesh vlookups?
Hi EVeryone- I have a sheet which contains the lookup values to my master sheet, and I have created a few datamesh lookup rules which works well, but if a new row gets added to my master sheet, I need to go to datamesh website and refresh the rules my self. Is there anyway I can automate this so everytime I dont have to go…
-
How to collect comments from individual sheets, cell-link to a master sheet (eventually Sights)
Hello everyone, For my dashboard (Sights), I show status updates from individual projects. There are multiple updates columns per project I have to pick up. For now, I added extra rows on top of project, and people fill in updates there. Then I cell-link those columns to a master sheet (and create a report for dashboard).…
-
Cell Linking Ability to Filter or Sort Source Sheet / Source Sheet does not stay filtered
All: I have looked but cannot find other questions regarding this topic. Apologize for any redundancy; and, thank you for any help on these two topics. Sandy Ability to Filter or Sort Source Sheet: From my (master) destination sheet, I click cell link icon. Then, I select my source sheet. Is there a way to filter or sort…
-
Linking to other sheets
Hello - I'm attempting to create a worksheet that would be our tracking for specific system setup requirements (checking the box that things are complete). I would also like to be able to allow for approvals, however I don't want each specific field being included on the approval. I was thinking of linking cells to another…
-
Smart Sheet Expert User
Seeking a smart sheet expert user able to to offer consultancy services. Wishing to use the software as a database to read and report on a number of sheets.
