-
Work around for Year transitions when using the WEEKNUMBER formula
Currently, I have a project starting in September 2025 and ending in June 2026. How can I use the WEEKNUMBER formula to create September 29,2025 as week 1 and continue the numbering sequence through June 1, 2026. I also need the formula to flow well when date changes are made to the plan.
-
Stumped with formula generated through AI helper
I recently created a formula using the AI tool, but it's returning #INCORRECT ARGUMENT SET and I can't figure out why. The prompt that I entered was: Count [Project] where [FY26] includes "Yes" or is blank, and where [Project Status] is not "Completed" or "Cancelled" The formula that the tool returned was:ā¦
-
In Smartsheet, how do I lookup and return different values from sheet 1 to Sheet 2 in one cell?
Hello, In Smartsheet, if I want lookup and return different values from sheet 1 (Test-IMS) to Sheet 2 (Test 2-SOS) in one cell, what should I use? Note: The two values from Sheet 1 will be different. Let me know if you have questions or I need to clarify more. Thanks,
-
Returning multiple results for a cell with multiple values
I have two sheets: one is a form collection table and the other is a reference table. One of the fields (Code) entered in the form collection table will determine who is responsible for the request submitted. The Code cell can have multiple values (separated by a comma and space). It is possible to have multiple peopleā¦
-
Multiple conditions for counting
Super-basic question regarding COUNTIFS. I'm trying to return a value that shows me a count of projects from a certain year, for a certain client. =COUNTIFS((Project Number:Project Number), Contains("2025", @cell ),(Client:Client), Contains("ADV", @cell )) But this comes up as unparseable. Where am I going wrong?
-
Editing Sheet Summary 'CY' Current Year - so my formulas update
I am attempting to enter the CY - Current Year into my sheet summary so I don't have to go through and update every cell formula when creating the new year's metrix sheets. What is the correct syntax in my formula so both CY are pink, indicating it references the CY in the Sheet Summary?
-
Time Zone Changing when forms submitted
Hi, I have created a few workspaces that are grids with the information coming from forms that are submitted every hour. All of my formulas and equations seem to be working correctly but am seeing an issue where the time zone constantly changes back to Pacific time when new forms are submitted (I am on eastern time). Myā¦
-
Finding Next Closest Date of Children
Ok hive mind - I haven't been able to talk this formula out with someone yet, so I am looking for a little help. I have the formula that will fill out the children of my FINAL DATE column, but to fill out the parent row, I want my formula to look at the children of the NON REFUNDABLE DEPOSIT column, and tell me what is theā¦
-
IF AND OR not working properly, last IF not triggering anything
Please help me figure out why this is not working: =IF([% Complete]@row = 1, "Completed", IF(AND([Start Date]@row <= TODAY(60), [% Complete]@row = 0), "Not Started", IF(AND(NOT(ISBLANK([Start Date]@row )), NOT(ISBLANK([% Complete]@row ))), "In Progress", IF(AND([Start Date]@row >= TODAY(61), [% Complete]@row = 0),ā¦
-
Sending an alert if any one of multiple columns changes after a deadline date
It doesn't appear that Smartsheet has an ISCHANGED function so I am struggling with an alert request. The request is for an alert if any one of 18 different columns has a value change after a deadline date. I guess I could create 18 Record Date automations on 7 different sheets to accomplish this, but that seems like aā¦