-
Running Count for Rows
I need assistance with a formula: If 'Request ID#' and 'Day of Contact' have the same info, then calculate the running total in 'Request Count'. I can't get my formula to work: =COUNTIFS([Request ID#]:[Request ID#], [Request ID#]@row , [Day of Contact]:[Day of Contact], [Day of Contact]@row , ROW():ROW(), <= ROW()@row ) I…
-
Rolling budget/spend tracker
I have a bit of quandary with a recurring task, wherein I am tracking weekly budget allocations and tracking what is NOT spent. Currently, I have a basic sheet where my contractors/vendors upload a patient record, which is just a sign-in sheet, and I manually count the hours used. Each of these sheets represents a maximum…
-
SmartsheetGOV - Cross Sheet Reference Token Broken?
Hi, I am working on setting up cross sheet references in SmartsheetGOV and it seems that the #UNPARSABLE error I receive is pointing to the token being broken. My formula is below. When I enter in "reference another sheet" it takes me through the steps to reference, but then it is inserted into the formula as plain text…
-
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…
-
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…
-
Looking for hopefully simple formula
Hi all. Hoping this is a simple formula. I want to make the blue highlighted column the same date as left column, but 2026. In this example, I would like blue column to be: 04/03/26 06/01/26 09/05/26 01/01/26 Please help, you'll save me a couple hours :)
-
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…
-
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 >…
-
Dashboard Pulling Week# and Year
Hello, We created a dashboard last year that pulled data from the week number but now that it's a new year, the data isn't pulling correctly. We added a year column, but haven't quite figured out how to do it correctly. Any help? Does this look correct? =COUNTIFS(WEEKNUMBER({PrintProductIntake-Week#}, [Primary Column]@row…
-
INVALID DATE TYPE
Hi, I created a formula that derives a value-based date range but if the date field is blank, I receive an INVALID DATE TYPE comment in that specific row. I read a few comments online that says if I apply the IFERROR operator, it will remove this error, but it returns “Incorrect Argument Set”. Here’s a sample of my…