-
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…
-
Calculate Start Date using a formula
I want to calculate the Start Date of a task using a simple formula. This is the Start Date column that interfaces to Resource Management, so that task and calculated Start date will be populated on the Assign To person's outlook calendar. Everything works EXCEPT the Start Date field does not seem to allow entering a…
-
Reminder Automation based on the Forgetting Curve
I am currently working on a project where I would like to set up automated reminders based on the Ebbinghaus Forgetting Curve to maximize information retention for my team members. I plan to use the following reminder intervals: 1 day, 1 week, and 3 weeks after the initial learning event. I aim to create a system within…
