-
Need help with a VLOOKUP and MATCH formula
Hi there, I confess I get so lost when it comes to formulas. I've read through various community discussions and help pages, but for some reason I just cannot get the logic of creating a formula. In sheet 1 I have a column for "Freelancer." In sheet 2, I have a one column for the "Freelancer" and one column for "Payee,"…
-
Calculating time between two timestamps in the same column
We were given some raw data from a virtual server and we need to calculate the session duration between 2 events in the same column and we cant figure it out the idea is to get the date from source table and on a formula sheet have the name of the agent, Date, Session Time start, Session Time End and Session duration Table…
-
Index, Match, Collect and/or Vlookup?
Hello, may I get assistance with a formula? Thank you. Sheet 1 ---> data in columns: Course Code, Section, Instructor Sheet 2 ---> column names: Course Code, Section, Instructor (blank) In sheet 2, I want to pull the instructor information from Sheet 1 based on course code and section in sheet 2. Here's what I have but…
-
Using TODAY function to calculate a half life
I am trying to use the TODAY function to continuously track half-lives of different radioactive material for inventory purposes. For example, if I order 50 mCi of lead 203 which has a half life of 51.8 hours, how can I make a formula to check how much has decayed in two days? Basically, is there a way to make the TODAY…
-
Drop down selection and cell updates
I have a column with drop down single select type name SLC Status. The entries in the drop down are "Requested", "In Review" , "Progress", "Testing", "Completed". There is a separate column for each entity ("Requested", "In Review" , "Progress", "Testing", "Completed"). My goal is- when Requested is selected from the drop…
-
Comparing 3 columns, one of which is a checkbox and returning days since.
If Already Released? checkbox is checked, return nothing ELSE If the Revised Release Date is blank, then look at Planned Release Date -Baseline and determine how many working days we are past due. If Revised Release Date is not blank, use that field to determine how many working days we are past due. =IF(ISBLANK([Already…
-
COUNTIFS criteria for "anything" in cross-sheet formula.
I've created a complicated cross-sheet formula that is supposed to the number of times the criteria "Mentioned" is found in Range 6 with an "any" criteria for Range 5 so that no matter what is in Range 5, if "Mentioned" is in Range 5, it will count it. This is what I tried: =COUNTIFS({Media Tracking Range 5}, {Media…
-
Is it possible to fix duration?
Hi, is it possible to fix duration so when I change the end date, the duration stay the same BUT start date is updated? See below, first picture is my starting point. Second picture is what happened when I change End date : duration is changing not the start date. Thanks,
-
How can I modify this equation?
I am running a report based off a request intake sheet that pulls the 1st choice date and 2nd choice date selected on a form request. This report will be put onto a dashboard and show only available dates (dates that have not been selected as either a first choice or second choice date on a form submission). I have created…
-
Connecting End Date or Duration from Jira to Smartsheet
I understand that I cannot bring over the end date from Jira to Smartsheet when there is dependencies/ one directional. Does anyone have a tip to use a duration field in Jira to populate the end date in Smartsheet? Or any other way to get an end date in Smartsheet from Jira? I have dependencies enabled in Smartsheet and I…
