-
Pulling data from different sheet that meets given criteria
Hi-- I am aware that I can select cells X1 - X50, for example, to reflect their sum on a different sheet. But in my case I am looking to automatically calculate sales on a separate sheet. So, out of a given list of prospects, I wish to pull figures only from those entries that have a checkbox associated with a sale in a…
-
Hyperlink to external drive
Hi all, I'm looking for a way to enter a hyperlink from another local shared drive in a Smartsheet cell. Is this somehow possible? Thx for your help! Warm regards, Gonnie
-
Web form populates parent/child relationship through category
Hello, was hoping to get some help on an issue i am having .. we have an inventory control sheet .. we would like to use a web form(s) to not only take out something of the inventory but to also add something to the inventory. I added a Category column and that is reflected in a dropdown list that matches all of the…
-
return list from another sheet
Anyone able to offer some help on the formula below - trying to return a list of information relative to an employee ID number to a column. There will be several matches per ID, e.g. Matt worked item 1.. 2... 3.. and 7. I want to return the information relative to that ID for those entries. Thanks in advance!…
-
Cell lookup and linking from another sheet
Good Morning All! Here is my dilemma if anyone can help. I have two worksheets. One has employee ID numbers and a box checked if they have a certain certification. Is it possible to create a formula that essentially says if box gets checked in worksheet A, look in worksheet B for name and check box in worksheet B? Or if a…
-
The sheet you selected is empty. Please select a different sheet.
I have a sheet with a count formula that references another sheet. I have been able to set up values to many cells already, then suddenly I started getting the error that the sheet I am trying to select is empty. I had deleted a "test" row, but even if I put information back in there, it won't allow me to select the new…
-
How to create an auto incrementing number based upon checkbox
Hi everyone, I have a smartsheet where each row represents an "installation". One of the columns is called "Gone Live" and is of a type checkbox. I have created another column entitled "Number of Installs this year". In this column, I want to create a formula that checks the "Gone Live" field, and if the checkbox is…
-
SUMIF IF referred sheet/column ISDATE
Hey everyone, working on something that i am having a problem with I have the following =SUMIF({FSM - Help Desk Ticket Tracker Range 4}, $VlookupValue@row, {FSM - Help Desk Ticket Tracker Range 1}) This returns the value from the cell that i want to perform a specific calculation. I want to add more to this though. The…
-
Summary Cells & Adding Rows
If I understand Smartsheets correctly, all formulas must reside within the sheet where the data exists meaning, if I want to display a metric or a total on a Sights Dashboard or Report respectively, I cannot. So, what do you recommend I do to create summary cells on a sheet where rows will be continuously added?
-
Linking action items to project tasks
Hello everybody, first time poster. I've searched the forum to find a solution, but I wasn't successful, so decided to create my own post. I'm new to smartsheet, so would appreciate help in getting a solution for my workflow I have a project sheet, with task names, start & finish dates, predecessors (dependencies enabled),…
