-
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.
-
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?
-
Set Dashboard as Default Homepage for All Users
Hi everyone, Is there a way to set a dashboard as the default homepage for all users upon login? Ideally, we’d like users to land directly on a particular dashboard instead of the usual default page. Is this possible through configuration, or is there a plugin or workaround that can help us achieve this? Thanks in advance!
-
Absolute Sheet References for use in formulas across multiple sheets
We use our own variation of the Project Management Template Set, and our PMs copy the folder when they are initiating a new project. We would like to include a formula in the project plan template for which the reference to another sheet will persist and work in the copy. This will help so that the PM doesn't have to…
-
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…
-
Project Cutover Planning
I have been working to transition my Excel based cutover plan to Smartsheet. I have read the posts about the challenges with Date and Time and having the ability to calculate duration with these challenges. Has anyone identified a truly viable option to track tasks at the minute, hour and day level for both child and…
-
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…