-
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??
-
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
-
Health and Wellness Solution
Good afternoon everyone. I am building a Health and Wellness Solution on my personal account to keep track of my health by logging things like; water intake, exercise (including type of work out, est calories burned, etc.), food intake, sleep tracking, weight log etc. Has anyone else done something similar using…
-
Data String Type Different in Budget vs Time & Hours Data for Advanced Reports in RM
Is this a bug or just a limitation? When I create an Advanced Report based on Budget data in RM, the Data String type in Smartsheet is automatically a Date format. However, when I create an Advanced Report based on Time & Hours data in RM, the Date String type is Smartsheet is in Text format. Is there a way to have them…
-
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…
-
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…
-
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…
-
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))…