-
Countifs with OR across multiple columns
Hello all, I'm a fairly new (2 weeks) smartsheet user and I'm trying to write a formula that will count several columns based on specfic criteria. I want to count the number of Open projects (status) that are associated with engineering by either person/dept assigned column 1 or 2, and are of a safety concern (category)…
-
Using SUMIF to provide value of orders from this week only
Hi, I am trying to get a formula to sum the total value of orders invoiced this week. The formula i have tried is below, but returns '0' as the value. =SUMIF({Completion Date}, {Completion Date} = WEEKNUMBER(TODAY()), {Order Value}) The sheet references are to single columns titled 'Completion Date' and 'Order Value'…
-
Formula to copy a value to cell which is defined by day of month
Hello! My goal is to create a sheet where I want to store the values which are updated every day during sync with Jira. And I want to copy a value to a cell that is corresponds to current day of week. The result should be something like on the screenshot. So I need some kind of formula: value from Jira copied every day to…
-
Connect Action log (dates) with a project sheet dates
Hello; I am currently working with two sheets, one is the project plan and the second one with an action log corresponding to one of the phases of the plan. I have an issue when I am trying to connect log date & due date of each of the actions of the action log, with the finish date of some of the activities from the…
-
Count if formula and task progress
Hi, I've been trying every way possible to set this up so hoping someone can assist-- I would like to create a dashboard with a pie chart that shows how many tasks with a due date for the past 30 days from a sheet are done or incomplete. This seems simple enough, but Smartsheet keeps telling me I can only use numeric…
-
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…
