Formulas and Functions
Archives for August 2020
Discussion List
-
Need help with a VLOOKUP and MATCH formulaIn Formulas and FunctionsHi 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 "Freela…
-
Calculating time between two timestamps in the same columnIn Formulas and FunctionsWe 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 na…Answered - Pending Review 218 views 2 comments 0 points Most recent by Juan Carlos Reguera Formulas and Functions
-
Index, Match, Collect and/or Vlookup?In Formulas and FunctionsHello, 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 infor…
-
Using TODAY function to calculate a half lifeIn Formulas and FunctionsI 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 ch…Answered - Pending Review 3 views 2 comments 0 points Most recent by Andrée Starå Formulas and Functions
-
Drop down selection and cell updatesIn Formulas and FunctionsI 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…
-
Comparing 3 columns, one of which is a checkbox and returning days since.In Formulas and FunctionsIf 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 …
-
COUNTIFS criteria for "anything" in cross-sheet formula.In Formulas and FunctionsI'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 "Menti…Answered - Pending Review 11 views 3 comments 0 points Most recent by Paul Newcome Formulas and Functions
-
Is it possible to fix duration?In Formulas and FunctionsHi, 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 cha…
-
How can I modify this equation?In Formulas and FunctionsI 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…Answered - Pending Review 33 views 3 comments 0 points Most recent by Genevieve P. Formulas and Functions
-
Connecting End Date or Duration from Jira to SmartsheetIn Formulas and FunctionsI 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 …Answered - Pending Review 165 views 1 comment 0 points Most recent by Isaac Jose Formulas and Functions
