-
Report not Matching Formula Issue
Hi, I have created a report to use on a dashboard for showing the number of job cards to print for our workshop. The report is shown below, and you can see that there are different amount of jobs to be printed for each workshop: You will see on here that there is: * 3x for the FASTRACK Workshop * 10x for the Van Workshop *…
-
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…