-
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…
-
How do I collect the most recent row data under a parent?
I have a sheet that I collect our vehicle information on each month. I manually move new rows to under the correct parent row. The issue I'm having is I can't find a formula to collect the most recent data from the children rows. I want the parent row in each circled column to behave the same way latest comment does and…
-
count if / v lookup formula
I'm trying to count the number of times the issue "- Originating Agency should be the origin of funds for University pass through funds" appears on a scrub report. I was using a simple count if statement at first but ran into an issue when two issues were reported for one proposal in a cell. I thought a work around would…
-
Need help with multiple If formula
Hello - I am having trouble converting an excel Ifs formula into smartsheet. I am able to get a single If formula to work, but cannot link them to each other - or even know if it is possible. Full disclosure, I am not very familiar with more advanced formulas. I have a column that has multiple entries. I created another…