-
Collect Data Based on Today's Date
Hi all. I'm trying to do something that I'm not sure if it's possible or not. We have a sheet that we are importing where the first column lists areas within our factory. Each column after that has a column name of a date. So 12/15/2025, 12/16/2025, 12/17/2025, etc. In each of the date columns is a target production…
-
IF Formula Not Working As Intended
Hi everyone! The below formula is not populating a 0 in cells that are new, as intended. The AI tool even says this formula should work, but it's not. After staring at it for hours, I can't figure out where I'm going wrong. Your help would be greatly appreciated!! Thanks! :) =IFERROR([Date Logged]@row - MAX(COLLECT([Date…
-
SUMIFS using Dropdown
Hello! I have what is probably a simple question my brain is just not comprehending properly. I need to SUMIFS from a sheet that matches some specific criteria but one of the fields I am using against needs to calculate a total if one dropdown field matches ANY ONE of these 3 items that is in it to be chosen… Capitol…
-
Has anyone used remote staffing (like CrewBloom) to support Smartsheet workflows?
Has anyone here used remote staffing support (like CrewBloom) to help manage Smartsheet projects more efficiently?
-
Calculating Monthly Revenue
I would like to sum monthly revenue estimates of projects on our schedule sheets. We have several projects that straddle different months, this IS where it gets tricky. Is it possible to build a formula that looks at a project and if the Start/End date straddles a month, it then calculates how many working days in each…
-
IF statement help
Hello, I have a checkbox column that I would like to be checked when comparing 2 columns. I would like it to be checked if the 2 columns are not equal or if one of the 2 columns has an error. It's important to note that both columns are numbers. My original formula was: =IF([COLUMN A]@row <> [COLUMN B]@row , 1, 0) However,…
-
Date/Time field should be Date&Time field
Timestamps are only included on Created Date and Modified Date but it is useful to have a specific timestamp that will not update every time the row/sheet is modified. This would be a huge help especially when using the Duration field or other formulas. Either update the Date/Time field to include the time like Created…
-
Have two auto-number or rank by created date?
Okay, so I have been working this problem for a few days and it's officially making me crazy. Here's the problem statement: I have 3 intake sheets for different business units. Each has an Auto-Number column that has a prefix for the BU. I need to consolidate all of the attachments from those 3 sheets into 1 sheet. So on…
-
Date format issued from date formula not recognized as date : message #DATE EXPECTED
Hello, I face one difficulty trying to transform text in date using DATE formula I want to find the first day of a week based on the week number & year number put in a cell For instance in a cell I find "25-45" FOR Year= 2025 & Week= 45, so I look for the monday of this week that should be the 3rd of nov Step 1 find first…
-
Smartsheet Filters
I’m hoping you can help me out with a question regarding Smartsheet. We have created a exception report within Smartsheet and I am having an issue with a client row being recognized when a filter is placed on the particular smartsheet. For Example: on the Exception main page you have 50+ clients listed with all exceptions…