-
Invalid Value error using INDEX & MATCH
Hi I copied a project PMO and reset the links from project metadata to the project input sheet for the new set. All the columns now return "INVALID VALUE". I changed some headings which match on both sheets, the formula shown was not changed. Any help would be appreciated. Steve
-
data storage - cell history
I was asked what kind of data are stored in backups. I could not find out if also the cell history will be stored in backups. Could you answer this?
-
Yellow RAG Formula: Between 2 Numbers (Greater Than Less Than)
Greetings Smartsheet Community: I Need to Add a Range in my Formula Between -9 & -1 to Turn Yellow. Thanks Current Formula: =IF(OR([Schedule Variance]@row > 0, [Schedule Variance]@row = 0), "Green", IF([Schedule Variance]@row <= -10, "Red"))
-
Time Formula
I have a client who I need to track if we met their SLA for service each month. We have a 4hr response time from the time the call comes in to first respond. We then have to resolve the issue in 48hr. Our system spits out dates and times of when the calls come in and when we completed them. Is there a formula for for a…
-
SUM IF a checkbox is checked
I have a checkbox named "Confirmed". I have two other columns "Scheduled Start Date" and "Projected Start" that Im wanting to Sum in a column called "Sync Alert Start". But I'm only wanting the Sum formula to return a value if the checkbox "Confirmed" is checked. If not, return 0. Here is what I've tried, but no success.…
-
Percentage Increase/Decrease
Hi there, I've looked at some other answers in the community but none seem to work for me. I'm trying to determine the % increase or decrease of values Year Over Year. Here's an example: THIS YEAR, we have a sheet that shows $125,000 in revenue. This time last year on a separate sheet, we showed $225,000. How do I create a…
-
RIGHT + FIND with LEFT + FIND
Hi, So I can run automations to notify individuals, I have a column that is a contact list. For data reporting purposes, I need to upload the names into an API in a (last_name, first_name) format. To get around this, I have concocted a two-step process: Write a function in a cell to pull back (first_name last_name) Write…
-
Need help with counting criteria within a date range
Hi - I am looking to count cells that are "in progress" within a specific month, for example, August. I use this formula but the count doesn't come up correctly. Can you help? Thank you! =COUNTIFS({Turnaround Plan Range 1}, "In Progress", {Turnaround Plan Range 2}, <=DATE(22, 8, 1) >= DATE(22, 8, 31))
-
Collecting latest date from another sheet that has multiple matching cells.
I have a master sheet that contains all of the items we have on order. Each individual order typically has multiple items and a separate delivery date. I need a formula to look through the data to return the closest delivery date listed for that item. I have tried INDEX(COLLECT, which I use all the time, I've tried…
-
Memorializing cell content
I have a column that calculates a date based on 'Column XYZ - 127'. This works perfectly. However, if 'Column XYZ' changes then my destination column will also change (obviously). But I want to preserve what the date WAS before it got changed. So I thought to insert a 'Helper' column and copy the date from destination to…