-
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…
-
COUNTIFS with more than 2 criterion
Hi, I am trying to do a count for a field with 3 criteria. I want to do COUNTIFS( A = "x", B = "y", and C = "Z"). Is there a way to achieve this as COUNTIFS only allows you to do this with 2 criterion?
-
Forms/Formulas
Hi, I have a Form/Dashboard on Smartsheet to book site induction on the project I am currently working on (see attached image). Just like every other Smartsheet forms, once the form is filled in it feeds into the sheet. Is it possible that once someone books an induction late (48 hours prior to the induction date) they get…
-
Creating workflows for repetitive tasks in Smartsheet
Hi How do I automate the workflows in smartsheet for repetitive tasks? For example Scenario 1: The issue has been raised by Testing team - which goes to the Development team, they modify the code, Testing team tests the modified code - if the issue is resolved, the issue is closed, if the issue is not resolved the cycle…
