-
Vlookup from another sheet to copy formula number
Hello, I am trying to determine how to get a cell copied into a sheet from another sheet based on certain criteria using a vlookup formula. Here is the sheet i would want the formula to autofill in. When Gunma (Asahi) and Aussie lemonade are chosen, I would like the formula number to autofill pulling from another sheet. So…
-
Find/Replace on Checkbox Column
Has anyone been able to figure out how to do a find/replace on a checkbox type column? I have tried 1, true, TRUE, True, "1", "true", "TRUE", "True", and none of them seem to trigger a match.
-
Looking for Formula Help - Health Status based on End Date versus Today
Good morning! I am looking for help with a formula as what I have entered returns "Unparseable". I am looking to return colors based on the below: If Status is Complete then "Green" If Status is in Progress but less than TODAY "Red" If Status is Not Started or In Progress and the End Date is greater than today by 7 days…
-
Extract Cell History For Formulas
Hello, Is there any way to extract the Cell history to calculate formulas. What I am trying to do is create metrics off the dates in the cell history. I.E. if a Dropdown list column starts on July 1 with Value 1 and changes to Value 2 on December 10th then Value 3 on December 21st. I want to measure and tract the time…
-
Is there a workaround to have a column with date (as function) to be recognised by workflows?
Dear Smartsheet Users, For my solution I need to have a date (always the same) in one column for more than 100 rows. The easiest way for me to do it is to write e.g.: ="03/04/23" and change this column to formula one so the same date will be for next row etc. However despite it's a Date column the workflows are not being…
-
IF AND FORMULA
Can anyone help with this formula please as i have tried to get it to work unsuccessfully but might even be barking up the wrong tree altogether =IF (NOT (AND (G2 = "COMPLETE",C2 < today()),"OVERDUE","")) Basically i want the cell to flag as 'OVERDUE' if G2 does not have complete in it and C2's date is less than today…
-
How do I count the number of times dates appear within a range?
Hi, I am trying to track the number of times a call occurs within a date range in a cross sheet reference formula. The user types the date on the call log and I would like to use the dates as a way to measure how many times calls occur within a week, month, and project to date . I have tried different ways, but I am stuck…
-
Request assistance with a formula to pull only the first name from a cell
Currently I have a form which helps me capture the First and Last name of the user among other information. The first and last name is captured in separate columns. However, 1% of the user inadvertently enters their full name in the first name section. The way I am trying to get around this issue is to have another column…
-
Need a formula for % completed to change status health, as well as % completed to update status
Hi there, I am after two formulas: FORMULA ONE I need my % Complete to reflect the Status, example below: 0% equals status - Not Started 1 - 99% equals status - In Progress 100% equals status - Complete FORMULA TWO I need my Health status to reflect the following: Completed equals Green In Progress equals Yellow Not…
-
Formula To Return Value based on Month
Hello, I am attempting to recreate a formula I have in Google Sheets to return a quarter number based on the Month. Ex: If a cell has "March", it would be Quarter 1. The original formula involved =IF(OR(ISNUMBER(SEARCH("December", F3)), in Google Sheets and I was able to have it work, albeit with several lines of text…
