-
SUMIFS PROBLEM
Hello, I want to create a formula to calculate the value in $. I want the exact same criteria as my COUNTIF. No matter what i try my formula with SUMIFS will not work. Thanks in advance for your help!
-
Use index that make dynamic formuale in the row.
I am trying to replicate an Excel dynamic sum in Smartsheet. I have a row containing data for weeks 1 through 52. I want to sum the values starting from the current week (based on today's date) through week 52. In Excel, I used a dynamic range, but Smartsheet is giving me an error. How can I sum a specific horizontal range…
-
Track Monthly Submissions from Multiple Locations
Hello! I have been using Smartsheet for a few years but have really only used the basics. I have a form for our branch managers to submit their monthly safety checklists and wanted to see if there was a way to track / indicate which locations did not submit and for which months. On the form, there is a drop down for them…
-
Formula - Counting and Blank Data
Hi. I need to know what is the best way to Count but exclude any cells that are blank. I am looking to count how many machines I have per my programs but I don't want to count the ones that have no date. I've read I should start with Is Blank but that didn't work. Thanks you in advance. Ali
-
Overall Project Health Based on Health of Milestones
We use the WBS for our project plans and indicate milestones by setting the duration to 0 and the start and end date as being equal. Our current column formula is =IF(ISBLANK([Start Date]@row ), "", IFERROR((IF(OR([Start Date]@row = "", [Start Date]@row > TODAY()), "Gray", IF(OR([% Complete]@row = 1, [End Date]@row >…
-
Averaging a number column from prior full weeks
I am having a hard time crafting a working formula. I have a Dashboard data sheet that I am pulling/calculating metrics into from other various Sheets. In one sheet, I have a date column {DID} and a Number Column {NOD}. I am trying to build a formula that will average the number column if the date column is in the last…
-
How can you calculate new date off of date fields?
I continue to get an error #INVALID COLUMN VALUE with my formula below. I have two restricted date fields RFP Decision Date and Actual RFP Award Date. I want to add the Estimated Approval Time, which is a number days value to the Actual RFP Date or if that is blank the RFP Decision Date, where we have a value in the…
-
Creating a formula to calculate Created Date column - not working correctly
If I am trying to create a metric formula to count how many rows were created today, created yesterday, created 3 days ago etc… by using the auto "Created Date" column. The current formula I am using is not properly adding them correctly =COUNTIFS({Ticket Tracker Range 1}, "COUNTING" , {Ticket Tracker Range 3}, =TODAY(-1))…
-
Match Function to Return Required Digits
Hi Smartsheet Community! I am running into a problem and need some help with a Row ID formula using the match function. I have a project plan that is generating a unique Row ID, using a combination of an Auto ID Column Type (Row ID), the Client & Project Code, and a match formula to return the actual position of the row in…
-
Table View - Show column links AND formula in row header
Currently, if there is a formula in a column and the data is part of a column link where that formula data is being sent elsewhere, the column only shows the Column Link icon… and doesnt show the formula icon. It gave me a minor heart attack today!!