-
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…
-
Sending An Update Request after 30 Days
Hello! I'm trying to send an update request to be alerted during the following time periods: 30 days after the initial row was added 60 days after the initial row was added 90 days after the initial row was added I have an "entry date" field to build off of to serve as the date the row was added. Is there a way to do this…
-
RYG Balls on Simple Formula
Hi...simply I want to show a red ball if my value is less than 1, green if it is greater than 5 and yellow if between? I'm missing something? =IF([Operations Metric]1 < 1, "Red", IF([Operations Metric]1 > 5, "Green", IF([Operations Metric]1, "Yellow")))
-
Sum(Children())
Another basic question - I have a column that uses the value in the 'Remaining Effort' to calculate the status of that task. At the Parent Level I am using Sum(Children()) to sum the Remaining Effort for the Child tasks. This works fine as long as there is a value in this field - if the Task has not started and 'Remaining…
-
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…
-
Pulling the last 50 results from long database?
I've got pages of test results (numerical values) that go back years that need displaying on a graph. New results get recorded every week. I'm after a way of making a chart that automatically updates to the latest x number of results (A year of results probably). The way the graphs work, they look at a fix range of cells…
-
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) =…
-
Determining Exact Match for Multiple Criteria in a Multiple Selection Dropdown
I am trying to grade a quiz where the answers were submitted via a smartsheet form. I am having trouble figuring out how to confirm that there is an exact match on questions that had multiple answers needing to be selected to be considered correct. On questions that only use one answer, this is the formula I use:…
-
Connecting End Date or Duration from Jira to Smartsheet
I understand that I cannot bring over the end date from Jira to Smartsheet when there is dependencies/ one directional. Does anyone have a tip to use a duration field in Jira to populate the end date in Smartsheet? Or any other way to get an end date in Smartsheet from Jira? I have dependencies enabled in Smartsheet and I…
