-
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…
-
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,…
-
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…
-
can I get automated reminders for a 30 day check in when dates in my start date column are different
I have a column titled "start date" for each of my employees. I would like a reminder sent to a manager at the 30-day mark after their hire date.
-
Formula just stopped working
I have a formula that I have used for years on a sheet and it was working an hour ago and then all of a sudden it just stopped working, I went out the sheet and back in and . The formula is =IF([Shop Order]@row = 0, (COUNTIF((RN:RN), RN@row ))) but instead of returning the value it says #INVALID COLUMN VALUE Got it working…