-
Formula for changing symbol colors
I created a column that changes symbol colors depending on the start date column. The below formula I put together after reading through some other posts within this community works alright except for the bit to have the symbol change to gray when the start date is today or past. What am I missing? =IF([Start Date…
-
INDEX help NO MATCH
I want to pull the dates into this data sheet from the Schematic prep column on the Master sheet. What's wrong with my forumla??
-
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))…