-
HELP! Column Formula working on some rows - not others
Hi! I'm stumped on this one. I am using a column formula to apply a date 21 days prior to the date in another column. Everything (formatting, etc) is the same on all the rows, but I keep getting "Invalid Value" errors on some rows and in other rows it works great. Does anyone have any ideas?? Formula: =DATE(YEAR([GT…
-
How to use LARGE function using criteria. AKA "How can I get the #1 risk based on criteria
I included all this information in the snippet but here is my issue. The issue is I cannot get a formula where the "Risk/Issue" column identifies whether it is a RISK or an ISSUE or an RISK BECOME ISSUE, and then give me the #1 item depending on that criteria, then the #2 item depending on that criteria, etc. My current…
-
How to capture the value (end result) of a formula for use in other processes
I've got formulas that return a result of a specific number depending on different keywords in certain cells on the spreadsheet. That's fine - they all work great! My problem is that I'd like to use those numbers (the end result) in other spaces in order to calculate totals for certain programs, by month and by year. But…
-
calculate maximum date
Hi everyone, I need your help to calculate the maximun data for each resource, starting from a sheet where the activities are recorded. I have a sheet where I write all tasks for each resource: I need to have the maximum date present in the "task" sheet for each resource present in the "resources" sheet Can you please help…
-
What formula can I create to get the correct SLA?
I know I can create a column to only include the date from the ticket was submitted and another for calculating the business days. However, I'd like to auto-populate the deadlines based on the triage options. Based on the selection of Triage options auto-populate a deadline from the time the ticket was submitted: Tier 1 –…
-
Multiple formulas on one sheet
Hello, I currently have a formula in column 1 of my sub-sheet copying data from my main source sheet. I'm trying to create a similar formula in column 2 of the same sub-sheet referencing my main source sheet. When I do this, the formula in column 2 is changing the formula in column 1. What am I doing wrong? The formula for…
-
How to average the time between various dates if conditions are met
I'm building a spreadsheet with monthly metrics and having issues creating a formula. There will be a separate smartsheet with individual events (1 row per event). Each event has ~3 review cycles. Each review cycle includes the date the draft was provided & the date the draft returned. Formula I'm trying to build: If the…
-
Since Smartsheet Gov has no sheet summary, where do I put formulas?
I have a sheet I want to move over to the gov version, and when I went to do that I noticed there is no sheet summary. My sheet has hundreds of formulas and it would be useless with out them. Any suggestions on where to put them? Do I make another column called sheet summary?
-
Percentage Inaccurate for Simple Calculation
Hello all, I was brought in to help with this formula on another sheet. I took care of the formula, but it doesn't seem to be accurate. They want to calculate the percentage of the one error @row out of the total errors. There 10 total errors right now, which allows for some nice easy math. However, when I calculate 1 out…
-
Calculating Average Submissions Per Day Formula
I cannot figure out what formula to use, and what rows to use in order to calculate how many submissions a day I receive on my sheet. Does anyone have examples of how they've calculated. I have the following date-related columns: Created Date Due Date Date Completed Days to Complete (a formula using the due date & date…