-
Combinations of seperate checkbox in rows activating a single count
Hello team! I am trying to categorize 4 different types of work and then also capture how much of each type of work we are approved for. I have four seperate columns of check boxes for different types of work and then a fifth for if the work is approved. the rows have the specific data for the specific work. How can I…
-
Report Total Number of Times a Cell was Modified
Hi Smartsheet Community! I need to be able to report on the total number of times one specific date field has been revised over the course of the project life cycle for trending purposes. I like that we have the ability to view the cell history by right clicking on the cell itself, but it would be nice if there was a way…
-
How do I set up "TODAY" and (-365) days and a NOT completed function for a metric sheet?
I am trying to set up a metric sheet to be used in a dashboard that I am creating. I want to show a count of all task that are not marked as completed with a due date of current day and back, up to 365 days, but I am receiving an #INCORRECT ARGUMENT error message. The function command I am using is: =COUNTIF((NOT({1.…
-
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…