The function I am looking for would allow for data to be pulled from a source sheet which is increasing in size and be kept in sync for maintaining accurate information. To help explain, at the moment…
I am trying to link two sheets. The main sheet contains all my essential information, however one column has a list of drop down options. If the user selects a certain option from the drop down I want…
Seeking an independent Smart Sheet Consultant to begin work no later that the 31st October 2017 6:00 PM GMT You should be able to screen share and use our already uploaded excel spread sheets to creat…
I am trying to have a column with dropdown choices auto-populate a value in the next column. If IP-A is chosen in the AssetType column, the TotalHours column should display 1. If IP-D is chosen the To…
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…
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 Thi…
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…
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 …