-
RYG formula for indicating expense vs. budget
Hi, I am trying to use RYG balls to indicate how much remains in a budget (red indicates 90% spent, Yellow indicates 75% spent) Using this formula, I get green and yellow, but I can't seem to get red, even though there are expense/budget over 90% =IF(Charged14 / [Budget Allocated]14 > 0.75, "Yellow", IF(Charged14 / [Budget…
-
If with multiple criteria along with VLookup
I am looking to use an "If" statement with multiple criteria combined with a VLookup. Within the formula below, I want the result to be blank if the Vlookup result is any of the terms I have specified, if it does not match, I want the Vlookup result to stand. =IF(OR(VLOOKUP([Row ID]26, {Bookkeeper List}, 2, false) =…
-
I am trying to create a formula that determines when date is within 30,60,90 days from todays date.
I am trying to create a formula that determines when date is within 30,60,90 days from today's date. The value if true will return the red, blue or green icons. The formula works if I only include"= but it does not work and returns Invalid Operations if I use <, >, <= This is the formula I entered: =IF(TODAY(30) >= [Date…
-
Specific Document Pages
Hi everyone, I've created a tracking sheet for multiple directives. We have a document that is produced every fiscal year to publish these directives. In one column we've listed the page number of the document that represents the directive. Is there a way to link the cell to a specific page within a document? I understand…
-
Filters Keep Resetting
I believe there was an update to smartsheets recently and since that update, I have noticed that my filters keep resetting themselves or disappear. Is there a glitch? I have never had this issue with filters in the past year of using smartsheets.
-
Calculate % Complete, but ALSO retain automated roll-up?
Hi Smartsheet Community, Has anyone successfully built a way to automatically enter a % Complete for a Task (row), but also still allow for that attribute to roll-up to a calculated % Complete at a parent level in a worksheet that has Dependencies enabled? I would like for a user to be required to select from a list of…
-
Quarters Gantt not being shown correclty
Hello, I am trying to configure the project settings to use quarters to show in the gantt view. However it is shown 2021 year and not 2020. Anyone know what it is the probelm?
-
Formula to subtract one month from a date
Hello. I need to subtract one month from a date. I have tried =Date-30, and then minus 60, etc. By month minus 5, I was quite a bit off from the first of the month. If the Date being evaluated is say 4/1/20, I'd like the first calculation to produce 3/1/20, and the next row to produce 2/1/20, and so on. I did find a…
-
Cross Sheet Distinct Count Formula
I'm trying to count distinct values in a different sheet using a cross sheet formula. More specifically, I have parent/child rows, and I only want to count the parent rows. The child rows have duplicate values in the column that I'm counting, which makes me think that something like countif(distinct(something...) will…
-
How to Use VLOOKUP and SUMIFS
I have 2 sheets. The first one is for case reviewer #1. It lists the case ID and the hours each day they worked on it. In total I have 3 reviewers and each have their own time sheet. Then, I have a summary sheet that lists the Case ID, each reviewer, and then the total time spent on each case. What I would like to do is on…