-
Help with COUNTIFS Formula
I'd like to count if the priority = high and the status = final version In other words, what is the total number of rows that equal both high priority and final version?
-
Sumifs Help with Month/Year and checkbox
I keep getting an error when writing this formula. Can someone please help? I want to sum the "Weighted Range" when "Prob Closing" is checked (1), and "Close Date" is January (1) of 2020. The 3 columns are in another spreadsheet. =IFERROR(SUMIFS({Weighted Range}; {Prob Closing}, 1; {Close Date}; MONTH(@cell) = 1; {Close…
-
Formula to display multiple rows
Hi, I am looking for a formula that would allow me to display a list of projects based on a client. Ideally, what I want is to have a dropdown column with a list of all the clients. When a client is selected then a list of their projects will display. This sheet would link to a master sheet of all clients and all projects.…
-
Pull Data from Master sheet to another sheet
Hello, I have a master vendor list sheet that contains a checkbox column for vendor type. I would like to create a new sheet that pulls over just the vendors that have the vendor type column checked. I need a separate sheet so I can use it for widget in my dashboard. I don't want to filter or sort the main master vendor…
-
Using data from one sheet to fill in a cell on another
I need a cell to populate based on a cell in another sheet. If sheet 1 contains the same number as sheet 2 column 1 then print notes from sheet 1 column notes else leave blank. This is what I have so far =IF(HAS({Sheet 1 Column 1}, [sheet 2]1), {Sheet 1 notes}, " "). {Sheet 1 Column 1} Refrences the entire column is sheet…
-
Sheet formula efficiencies
Hi, I have a feeling that I should be using "@cell" or "@row" in a formula to make less calculations. Can anyone shed light on a better formula than the one I have started? Basically trying to determine if a date falls between two other dates through a range (i.e. find out which year/quarter that a specific dates falls…
-
Return value in Parent Cell for Child value
I have been trying to use the Index & Match function to automatically populate in the Parent row based on the status of a Child row, however, the formula will not pick up the Child status. For example, I want the STATUS column of the Parent row to populate with the STATUS of the Child where the Child DOCUMENT TYPE = "Trust…
-
How to "actualize" or transfer dependencies of a completed task?
Task A Task B is dependent on Task A Task C is dependent on Task B For some reason, I was able to finish Task B and Task A was getting delayed. How do I: 1. Extend duration of Task A without impacting dates, duration or status of Task B? 2. Mark Task B complete, such that actual completion dates do not change irrespective…
-
Formula Assistance
Hi All A newbie to Smartsheets, so please bear with me. I have a formula that works on excel but not on Smartsheets….any ideas why? Excel: =IF(K44="Approved",SUM(F43-C44),IF(K44="Declined",F43)) Smartsheets: =if([Approver approval]43="Approved",sum([Days Remaining]42-[Annual Leave]43,if([Approver…
-
DATE function for drop down menus
Hi all, I am using a drop down including different years (2019, 2020, 2021, etc.) that I need for the card view. Based on the selected drop down value in Column 1 (e.g. 2020) I want to auto-populate a ‘date’ field with the first day of the year (e.g. 2020.01.01) in column 2. I tried to use the following: = DATE ([Column…